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 / 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 |
Post New Answer View All Answers
What happens to the indexes if a table is recovered?
What is a database table in oracle?
How to best split csv strings in oracle 9i?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
What happens to the current transaction if the session is ended?
How to add another datafile to a tablespace?
What is oracle open database communication (odbc)?
How to turn on or off recycle bin for the session?
How to drop an existing table in oracle?
Explain the use of Merge statement in oracle 11g
What is a trigger and what are its types in oracle?
What is an oracle transaction?
How to use subqueries in the from clause in oracle?
Why cursor variables are easier to use than cursors?
Can group functions be mixed with non-group selection fields?