Two triggers one is before insert and other is after insert
are firing on a table.If 10 times you insert in a table.Then
how many times before trigger and how many types after trigger
will fire in pl/sql.
Explain the use of online redo log files in oracle.
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.
what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .
How to export data to a csv file?
How to get a list of all background sessions in the database?
select trunc(round(156.00,-1),-1) from dual;
How to fetch the row which has the max value for a column?
What is a procedure in oracle?
Explain drop constraint oracle?
How to write a query with an inner join in oracle?
What is Hash Cluster ?
How to create a stored program unit?