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
- 19813 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 the function that is used to transfer a pl/sql table log to a database table?
what is cursor. write example of it. What are the attributes of cursor.
What is a left inner join?
Explain the structure of pl/sql in brief.
How do I partition in sql?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
what is heap table? : Sql dba
What is memory optimized table?
How do you add a column to a table?
Differentiate between sga and pga.
What is trigger in sql? Explain
How does sql developer connect to oracle database?
Can a commit statement be executed as part of a trigger?
What is exception? What are the types of exceptions?
Differentiate between syntax and runtime errors.
