you are sorting a table using "order by"(descending) clause of
a column which contains a null value...whether that row
containing null value will come first or last in the output??
Answer Posted / vignesh lakshmirajan
The column contains null value will come first.. COz oracle consider the null value as larger value in this case....
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
What is an oracle transaction?
Explain the use of rows option in imp command.
What are advantages of dateset in datastage?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
What are a collation and state the different types of collation sensitivity?
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 view is different from a table?
Please explain oracle data types with examples?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How to define an external table with a text file?
How to see the table columns used in an index?
How do you tell what your machine name is and what is its IP address?
How to add a new column to an existing table in oracle?
What is oracle rowcount?
Difference between inner join vs where ?