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??
Answers were Sorted based on User's Feedback
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 |
Answer / 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 |
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
What is the difference between hot backup and cold backup in oracle?
Find all employees in Dept “Marketing”.
What is a system tablespace?
How to create a new table in oracle?
10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.
Explain cascading triggers.
Is primary key = unique key,not null? If yes,please explain IF No,please explain
How does the on-delete-cascade statement work?
how to insert data into partitioned table partition done by Range partition
What is Partitions in Table ?
How to compare dates in oracle sql?