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
- 19945 Views
- Oracle, TCS, Tecnics, I also Faced
- E-Mail Answers
Answer Posted / jyothi
greatest gives largest value from the list of values passed
where as max gives maximum value in that column.similarly
least and min too.
decode performs only equality conditions and it doesn't work
in plsql.process null.
case compares all the cases.null cannot processed. case
performs all the actions of decode and it works in pl/sql.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is dcl in sql?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
What is sql scripting?
What is pl sql variable?
How many sql core licenses do I need?
how to get a list of indexes of an existing table? : Sql dba
What is dynamic sql in pl sql?
Is oracle sql free?
what tools available for managing mysql server? : Sql dba
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
What is cte?
How many sectors are in a partition?
How to take user input in pl sql?
how to drop an existing table in mysql? : Sql dba
