Oracle plsql All Commands

Enable output 1 SET SERVEROUTPUT ON Comments 1 2 3 4 5 6 7 -- single line comment /* multiple line comment */ Setup tables 1 2 3 4 5 6 7 8 9 create table rahul_emp as select ...

%rowtype for complete row into 1 2 3 4 5 6 7 8 9 10 declare mrec rahul_emp%rowtype; begin select * into mrec from rahul_emp where empno=7900; dbms_output.put_line(' the salary of employ...

control statement if ,elsif, else, end if 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 declare mrec rahul_emp%rowtype; mempno rahul_emp.EMPNO%type; service_years number; ...