Thursday, 6 March 2008

Typical PL/SQL Query

DECLARE
x NUMBER;
z NUMBER;
a NUMBER;
y VARCHAR2(100) := 'Shane';
BEGIN
x := 73600;
z := 26378.234;
a := x + z;

dbms_output.put_line(y || ' says ' || x || '+' || z || '=' || a);
END;

|| - Is a string concatenator.

No comments: