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
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How to use "in" parameter properly?
How to create a table index?
Explain the types of exception?
Can we convert a date to char in oracle and if so, what would be the syntax?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Explain the use of grant option in imp command.
How to use attributes of the implicit cursor in oracle?
What is a static data dictionary in oracle?
Explain the use of online redo log files in oracle.
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 set a transaction to be read only in oracle?
Respected sir, Please send me technical questions related to oracle apps..
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
Why do we use coalesce function in oracle?