What does `(+)` do in a where clause?
what is load balancing and what u have used to do this?(sql loader)
Can anyone give me information about oracle certification
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How to find 1st, 2nd, 3rd highest using select select statement not using rownum
List the parts of a database trigger.
How can you use check constraints for self referential integrity?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
12 RULES OF RDBMS
There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep
Explain enable novalidate constraint.
How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10
Can we commit inside a function in oracle?