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
- 19752 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 are mysql timestamps seen to a user? : Sql dba
How to change the order of columns in Oracle SQL Plus ?
explain advantages of myisam over innodb? : Sql dba
What is a native sql query?
Does db2 use sql?
How do I run a program in pl sql?
How do I view a view in sql?
How does left join work in sql?
Is oracle and sql same?
What are the two types of exceptions in pl/sql?
How do you change a value in sql?
How do I view a sql database?
Enlist the data types that can be used in pl/sql?
how to fetch alternate records from a table? : Sql dba
how would you enter characters as hex numbers? : Sql dba
