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
- 5092 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 |
List out the components of logical database structure of oracle database.
how many outer joins are used in a single sql query? is there any limitations for using of outer joins?
2 Answers BOB Technologies, Cap Gemini, IBM,
What is the best way to do multi-row insert in oracle?
What is a Redo Log ?
What are the uses of Database Trigger ?
Explain the difference between a procedure and a function?
what is the use of rank function?
How to create a stored function in oracle?
Why do we need oracle client?
Explain temporal data types in oracle
How to commit the current transaction in oracle?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Oracle General 
