wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and d

wt is the diff b/w greast and max ,least and min?
wt is the diff b/w case and decod?

Question Posted / prakasha

4 Answers
18323 Views
Oracle, TCS, Tecnics, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?..

Answer / satya

simply greatest,least are rowlevel functions
max,min are the column level functions

Is This Answer Correct ?

10 Yes

2 No

wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?..

Answer / shivaindu

greatest/Least: we can pass any no. of exp
Max/Min: we can pass one exp that may a column

Case: is a statement function, cannot process null
Decode: is a function, can process null, we can use in
update statement.

Is This Answer Correct ?

10 Yes

3 No

wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?..

Answer / 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

wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?..

Answer / prakasha

Is This Answer Correct ?

2 Yes

15 No

Post New Answer