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


Please Help Members By Posting Answers For Below Questions

What is the parameter mode that can be passed to a procedure?

581


How to select some rows from a table in oracle?

606


How to rename an existing table?

619


What is tns name?

553


How to find out what oracle odbc drivers are installed?

588






Describe varray?

601


Explain the difference between sql and oracle?

590


What is a tns service name?

548


How to view all columns in an existing table?

556


What is a system tablespace?

614


Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

1668


State the difference between a primary key and foreign key?

523


How to convert a date to char in oracle? Give one example.

601


What is difference between sid and service name in oracle?

525


What is meant by joins?

635