What is trigger and how to use it in sql?
what is difference between stored procedures and application procedures,stored function and application function?
What is the difference between having and a where in sql?
SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;
What do you understand by pl/sql packages?
Can 2 queries be executed simultaneously in a distributed database system?
What is loop in pl sql?
Hi all, I am going to write oracle certification. Can anyone send me the dumps available if any for OCA exam? Its really very urgent, prompt response will help me alot..
What is the location of pre_defined_functions.
ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.
What is Referential Integrity?
What are the different dcl commands in sql?
What is an inner join sql?