Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
Whatz the main diff between Subquery and a Join
14 Answers Oracle, Zeta Interactive,
What are the execution control statements?
How can we create the complete backup of data in the oracle.
0 Answers IPEC, Satyam, SunTec,
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.
How does one get the view definition of fixed views/tables?
What is a proxy class?
how to use sequence and what use of sequence cache
why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?
19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.
We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?
Explain the use of indexes option in exp command.