1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / prakasha

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

n0

Is This Answer Correct ?    2 Yes 15 No

Post New Answer

More SQL PLSQL Interview Questions

What is mutating sql table?

0 Answers  

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

0 Answers   MCN Solutions,

how to create user in sql and how to set password for that?

3 Answers  

i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id. pls give me answer. i want urgent

3 Answers  

what is schema? : Sql dba

0 Answers  




What is primary key secondary key alternate key candidate key?

0 Answers  

What are sql procedures?

0 Answers  

What are different categories of sql commands?

0 Answers  

When we give SELECT * FROM EMP; How does oracle respond?

24 Answers   Accenture, HCL, Infosys,

How to disable a trigger name update_salary?

0 Answers  

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

0 Answers   Prodapt,

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

For more SQL PLSQL Interview Questions Click Here
Categories