Sunday, September 25, 2016

3i-infotech Oracle SQL PL/SQL Interview Questions

3i-infotech Oracle SQL PL/SQL Interview Questions

Explain your project
difference between case and decode
difference between procedure and package
select * from emp what are the steps to follow sql engine to display the output
what is parsing and types of parsing
what is materialized view
what is the use of forward declaration
can we use commit in trigger, without pragma can we commit trigger it is compile or not.
we are using :old,:new , before trigger processing  what is the value of :new.
create table a;
delete from b(10 records);
roll back;
select count(*) from b; what is the output

No comments :

Post a Comment