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
- 5739 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 is connection pool in oracle?
what is the exact diiference between DBMS and RDBMS
How to display First 4 rows From Database Table?
How to write a query with an inner join in oracle?
What is an UTL_FILE.What are different procedures and functions associated with it?
How to use attributes of the implicit cursor in oracle?
How do I spool in oracle?
Explain the relationship among Database, Tablespace and Data file?
how to get the no employee in each department including the dept which has 0 employee
How to retrieve values from data fields in record variables?
How to create id with auto_increment on oracle?
One Table having two rows with one colomn having values Like"Male" and "Female". how to upadte these values Like "Female" and "Male" in single update statement.
Oracle General 
