Interested to Buy Any Domain ? << Click Here >> for more details...
wt is the diff b/w greast and max ,least and min?
wt is the diff b/w case and decod?
- 4 Answers
- 19744 Views
- Oracle, TCS, Tecnics, I also Faced
- E-Mail Answers
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
Why truncate is faster than delete?
What are the different ddl commands in sql?
Where not exists in sql?
Can we alter stored procedure?
List and explain the different types of join clauses supported in ansi-standard sql?
Why do we need cursor in pl sql?
Will truncate release space?
What is synchronized subquery?
What are all the different normalizations?
what is a tablespace? : Sql dba
how to dump a table to a file with 'mysqldump'? : Sql dba
What are the types of views in sql?
Is oracle sql free?
Does truncate table reset auto increment?
Do we need to rebuild index after truncate?
