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
- 5768 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 to define an anonymous procedure with variables?
What is the usage of control file in oracle?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How to convert raw data type into text in oracle? Explain
What is merge statement used for?
How to convert characters to times in oracle?
Can we write insert statement in function in oracle?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
What are the uses of Database Trigger ?
Difference between varchar and varchar2 data types?
What are the logical operations?
When do I need to use a semicolon vs a slash in oracle sql?
Explain an exception and its types?
What are the differences between char and varchar2 in oracle?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
