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 delete command in sql?
What does (*) mean in sql?
How many types of cursors supported in pl/sql?
where are cookies actually stored on the hard disk? : Sql dba
when is the use of update_statistics command? : Sql dba
Why functions are used in sql?
What is sql architecture?
Is sql developer case sensitive?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
Can we use insert statement in function?
Is sqlexception checked or unchecked?
what is error ora-03113: end-of-file on communication channel?
What is a constraint?
explain about mysql and its features. : Sql dba
What is microsoft t sql?