Interested to Buy Any Domain ? << Click Here >> for more details...
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??
- 2 Answers
- 5859 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / suman rana
if you are sorting a table using "order by"(descending)
clause of a column which contains a null value, row
containing null value will come first. Alternatively you can
use the clause "Nulls First" along with order by clause to
appear the Null values first.
| Is This Answer Correct ? | 9 Yes | 0 No |
What happens if recursive calls get out of control?
how do u setup a replication site?
Explain coalesce function?
Why we choose emp number as primarykey?
What are the different editions of oracle?
how to retrieve data from different tables ,place this data in different excel worksheets.
What is pragma autonomous transaction in oracle?
What is the difference between hot backup and cold backup in oracle?
what is RAID technology?which is better RAID 0+1 OR RAID 5?
How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?
How many data types are supported?
What is the difference between formal parameters and actual parameters?
Oracle General 
