100 SQL Interview Questions

• What is DBMS and RDBMS.
• What are constraints
• What is primary key.
• What is unique constraint.
• What is index, explain its different types.

Using %Type while creating plsql variable 

We can use %Type while declaring variable 

example 

declare 

v_wonum workorder.wonum%TYPE;

begin

end;