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??
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
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
What is the data pump export utility?
How remove data files before opening a database?
Explain the difference between a procedure and a function? What do you understand by those terms?
Explain a synonym?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
When do you get a .pll extension in oracle?
What is a schema in oracle?
Explain rename?
Describe the types of sub query?
How to delete a column in an existing table in oracle?
How to create a new view in oracle?
How many types of database triggers exist?
How do we represent comments in oracle?