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
- 19800 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
Do we need to rebuild index after truncate?
Who is the owner of mysql database?
What is a record in a database?
What is the main difference between sql and pl/sql?
Is primary key a clustered index?
What are the parts of a sql statement?
Can we use ddl statements in stored procedure?
Can procedure in package be overloaded?
What is tuple in sql?
How to run sql functions in pl/sql?
what is meant by urlencode and urldocode? : Sql dba
What is assignment operator in pl sql?
What is form and report?
What is sql scripting?
What is mutating error?
