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 oracle sql,pl/sql with interfaces

2 Answers   TCS,


Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?

3 Answers   eBay,


What is ON DELETE CASCADE?

3 Answers  


We have a CURSOR then we need BULK COLLECT?

1 Answers  


What is the relation b/w view and trigger

3 Answers   Accenture, TCS,






HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?

2 Answers  


What is Overloading of procedures ?

2 Answers  


I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?

2 Answers  


What are the PL/SQL Statements used in cursor processing ?

4 Answers  


Delete duplicate records in the emp table.

6 Answers   Oracle,


There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?

1 Answers   Cognizant,


difference between table level constraint and column level and advantages of table level constraint

4 Answers   Doyensys,





Categories