wt is the diff b/w greast and max ,least and min?
wt is the diff b/w case and decod?
- 4 Answers
- 18977 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
Is sql sequential or random?
How is sql used in oracle?
Why do we use %rowtype & %type in plsql?
How to get each name only once from an employee table?
What is pl/sql language case sensitive?
What are analytic functions in sql?
What is difference between my sql and sql?
Explain exception handling in pl/sql?
How do I save the results of sql query in a file?
What are the query optimization techniques?
What is microsoft t sql?
Does google use sql?
What are the advantages of indexing?
What is gpt format?
Why is sql better than hql?
