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
- 19614 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 do you mean by stored procedures?
What is sql profiler in oracle?
which operator is used in query for pattern matching? : Sql dba
What is clustered and nonclustered index in sql?
How do you change a value in sql?
What are sql commands?
What are the different types of sql commands?
What is sql scripting?
How do I get sql certification?
How many types of tables are there?
What operating systems are supported by oracle sql developer?
What are the two types of cursors in pl sql?
what is meant by nl2br()? : Sql dba
What is meant by user defined function?
Why is a primary key important?
