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
Where do we use decode and case statements?
How to convert times to characters in oracle?
How to write numeric literals in oracle?
What is private procedure oracle?
6. Display the client name and order date for all orders using the traditional method.
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is a cursor in oracle?
What is the order of defining local variables and sub procedures/functions?
What are nested tables?
How to initialize variables with default values?
Can we connect to ORACLE db using Windows Authentication?
How to convert characters to numbers in oracle?
How to start an oracle instance?
How will you write a query to get a 5th rank student from a table student_report?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?