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
- 4878 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
How do you bind variables in oracle?
What are the differences between interval year to month and interval day to second?
What is the data pump import utility?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
What is a table index?
What is ADDM Advisor in Oracle?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
What are the uses of synonyms?
Why use resource manager in Oracle?
What types of joins are used in writing subqueries?
What happens to the current transaction if a ddl statement is executed?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How many anonymous blocks can be defined?
How to start a new transaction in oracle?
How many types of tables supported by oracle?
