RDBMS PL/SQL Basic Programs

 

RDBMS Programs

1)  Program to print Hello World.

SET SERVEROUTPUT ON

BEGIN 

    DBMS_OUTPUT.PUT_LINE('Hello World');

END;

/

Output

Hello World

 

PL/SQL procedure successfully completed.

2)  Program to demonstrate the use of variable.

SET serveroutput ON

DECLARE

     name varchar(40);

BEGIN

     name := 'Chirag Mewada';

     DBMS_OUTPUT.PUT_LINE('Hello ' || name);

END;

/

Output

Hello Chirag Mewada

 

PL/SQL procedure successfully completed.

3)  Program to demonstrate the use of %TYPE.

SET serveroutput ON

DECLARE

     name Worker.FIRST_NAME%TYPE;

BEGIN

     SELECT FIRST_NAME INTO name

      FROM Worker

      WHERE WORKER_ID = 002;

     DBMS_OUTPUT.PUT_LINE('Hello ' || name);

END;

/

Output

Hello Chirag Mewada

 

PL/SQL procedure successfully completed.