Thursday, 28 July 2011

2nd PL /SQL Program

DECLARE

emp_name_c CHAR(32);
emp_name_v VARCHAR(32);
BEGIN

emp_name_c := 'sateesh.bagadhi';
emp_name_v := 'sateesh.bagadhi';

IF emp_name_c = emp_name_v THEN
DBMS_OUTPUT.PUT_LINE('The names are the same');
ELSE
DBMS_OUTPUT.PUT_LINE('The names are NOT the same');

END IF;
END;
/

output:

Writing and Running PL/SQL Program in windows

Step1) Write the PL/SQL code in the note pad and save it as with extension name .sql
ex: "test.sql"

DECLARE
x NUMBER;
BEGIN
x := 72600;
dbms_output.put_line('The variable X = ');
dbms_output.put_line(x);
END;
/

step 2) oracle sql*plus
type
SET SERVEROUTPUT ON
@ c:\orabook\test.sql

OUTPUT:
SQL> set serveroutput on
SQL> @ c:\orabook\test.sql
The variable X =
72600

PL/SQL procedure successfully completed.


Thursday, 28 July 2011

2nd PL /SQL Program

DECLARE

emp_name_c CHAR(32);
emp_name_v VARCHAR(32);
BEGIN

emp_name_c := 'sateesh.bagadhi';
emp_name_v := 'sateesh.bagadhi';

IF emp_name_c = emp_name_v THEN
DBMS_OUTPUT.PUT_LINE('The names are the same');
ELSE
DBMS_OUTPUT.PUT_LINE('The names are NOT the same');

END IF;
END;
/

output:

Writing and Running PL/SQL Program in windows

Step1) Write the PL/SQL code in the note pad and save it as with extension name .sql
ex: "test.sql"

DECLARE
x NUMBER;
BEGIN
x := 72600;
dbms_output.put_line('The variable X = ');
dbms_output.put_line(x);
END;
/

step 2) oracle sql*plus
type
SET SERVEROUTPUT ON
@ c:\orabook\test.sql

OUTPUT:
SQL> set serveroutput on
SQL> @ c:\orabook\test.sql
The variable X =
72600

PL/SQL procedure successfully completed.