Answer Posted / lokanath
In Oracle 9i Natural Join,
ON clause,
Using all are added.
COALESCE Function is added.
MERGE Statement
and few more features are added.
| Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
How do I recompile a procedure in oracle?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
How to rename an existing table?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
How to convert times to characters in oracle?
What is tns name?
How a tablespace is related to data files?
Are truncate and delete commands same? If so why?
What is MTTR advisor in Oracle?
What is a procedure in oracle?
How to update a table row with a record?
how the indexes are stored in the Oracle Database?
Name the three major set of files on disk that compose a database in Oracle?
How to use regular expression in pattern match conditions in oracle?