wt is the diff b/w greast and max ,least and min?
wt is the diff b/w case and decod?
- 4 Answers
- 18303 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
How to fetch alternate records from a table?
What is trigger in pl sql with examples?
What is rownum?
What is %s in sql?
Where the sql database files are stored?
What are expressions?
Where is all the data on the internet stored?
What are data types in pl sql?
What does count (*) mean?
Can we create index on primary key?
when MSQL8.0 is in market
How do I add a database to sql?
What is use of trigger?
What is sqlcommand?
What is data abstraction in sql?
