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
- 5853 Views
- BirlaSoft, I also Faced
- E-Mail Answers
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
How to create a stored function in oracle?
How do I limit the number of oracle database connections generated by weblogic server?
How to create additional tablespaces for an new database?
How to define a variable to match a table column data type?
Why does oracle 9i treat an empty string as null?
What is Library Cache in Oracle?
How to use group functions in the select clause using oracle?
In the oracle version 9.3.0.5.0, what does each number shows?
Can you drop an index associated with a unique or primary key constraint?
How to retrieve data from an cursor to a record?
What are the arithmetic operations?
Why do you use stored procedures and state some of its disadvantages?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
What happens to the current transaction if the session is killed?
How will you identify oracle database software release?
