The column contains null value will come first.. COz oracle consider the nu

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??

Question Posted / vignesh lakshmirajan

2 Answers
5827 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

Please Help Members By Posting Answers For Below Questions

What is an oracle tablespace?

1032

How to declare a local variable?

1101

What is the oracle implicit cursor?

1046

When do you get a .pll extension in oracle? Explain its importance

1027

How to insert multiple rows with one insert statement in oracle?

1068

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1856

How can we create the complete backup of data in the oracle.

2143

Can multiple columns be used in group by in oracle?

969

How many types of segments in Oracle?

1061

what is meant by magic query

2170

What are the differences between number and binary_float in oracle?

1095

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

1050

How to load data through external tables?

1127

Hi Can any one tell me what are the API's used in requisition import.

1913

What is the usage of control file in oracle?

1076