wt is the diff b/w greast and max ,least and min?
wt is the diff b/w case and decod?
Answer Posted / shivaindu
greatest/Least: we can pass any no. of exp
Max/Min: we can pass one exp that may a column
Case: is a statement function, cannot process null
Decode: is a function, can process null, we can use in
update statement.
Is This Answer Correct ? | 10 Yes | 3 No |
Post New Answer View All Answers
What is user defined functions?
What is Collation Sensitivity ? What are the various type ?
Which is faster count (*) or count 1?
Why do we use joins in sql?
How does one use sql*loader to load images, sound clips and documents? : aql loader
What is assignment operator in pl sql?
What are the triggers associated with image items?
What does count (*) do in sql?
What are the advantages of sql? Explain
Does view store data in sql?
Is not null in sql?
Explain table and field in sql?
What version is sql?
What is the difference between pl and sql?
Is ms sql is free?