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
- 4863 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 the use of file param in imp command?
Explain oracle insert into command?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
Explain the use of owner option in exp command.
what are the advantages of running a database in archive log mode?
How to invoke the original export import utilities?
What happens to the current transaction if a ddl statement is executed?
How to shutdown your 10g xe server?
select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help
What are the tools for Oracle ?
I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it
what is the difference between UNION AND UNIONALL
Oracle General 
