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
- 5712 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answer Posted / vignesh lakshmirajan
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 |
Post New Answer View All Answers
Explain about the analyze command in oracle?
How to omit columns with default values in insert statement in oracle?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
How to display employee records who gets more salary than the average salary in the department?
How do I manually uninstall oracle client?
Can we protect our pl/sql source code?
Is there any function in oracle similar like group_concat of mysql?
What is index-organized table in Oracle?
How can I introduce multiple conditions in like operator?
How to define an anonymous block?
What is a cursor and what are the steps need to be taken?
Explain drop constraint oracle?
How to delete a user account in oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
How to load data through external tables?
