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
What is oracle and what are its different editions?
How to get a list of all background sessions in the database?
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.
what is difference between sql plus and sql*plus? (not sql and sql plus).
How to execute a stored program unit?
What is sequence?
What are the data types in oracle?
Is insert autocommit in oracle?
How to fetch the row which has the max value for a column?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
How to connect to a local oracle 10g xe server?
What is the maximum number of triggers that can be applied to a single table?
How translate command is different from replace?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
how to join query for one source type is oracle another source type is sql server ?