How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's.

You shouldn't use more than one select statement in entire the program.
Like cursor c is select * from <table_name>;
except this you can't use another select statement.
You can use no of variables as per requirement.

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

What is a bitmap index?

4 Answers   Choice Solutions, Infosys,

What is the basic structure of PL/SQL ?

6 Answers  

What is Referential Integrity?

3 Answers   IBM,

what is oracle sql,pl/sql with interfaces

2 Answers   TCS,

How to find the count of letter "L" in HELLO

6 Answers   HP,

HP Interview -2016 Unix 1) grep command in unix 2) what is set command

1 Answers   HCL,

hi sql gurus, here is my question 4 u. i wanna use triggers for sending reminder mail to all users who are registered to the site. if any one knws the code plz send me ans here : thnx advance

1 Answers  

how to create object in plsql

2 Answers   TCS,

Maximum how many triggers can we use in trigger and How to find out how many records it fetched.

1 Answers   TCS,

Could you please provide oca (oracle 10g) dumps for my certification ?

1 Answers  

what is sql optimization

1 Answers   Fidelity,

What is Temp Table and type of temp table?

0 Answers   HP, SLK,