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 / 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
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
Explain an index?
How to get a create statement for an existing table?
What is the use of aggregate functions in oracle?
How to drop a stored function?
Explain the difference between a procedure and a function? What do you understand by those terms?
What are the different types of synonyms?
What is the usage of save points in oracle database?
How to define a data source name (dsn) in odbc manager?
how can we store any pdf file in oracle
Please explain drop constraint oracle?
What's dateware house and what's clustor with practicle example
Explain parameter file in oracle.
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
What are the built-in functions used for sending Parameters to forms ?