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
- 5938 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 |
How to invoke the data pump export utility?
How to convert numbers to characters in oracle?
Point out the difference between user tables and data dictionary?
How to drop a tablespace?
How to do paging with oracle?
how to truncate date and get only time part 9:20:00
How can you merge two tables in oracle?
how to tune oracle sql queries pls tell me step by step. urgent pls
Is java required for oracle client?
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
What is the difference between post-database commit and post-form commit?
Oracle General 
