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
what is oracle sql,pl/sql with interfaces
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 !!?
What is ON DELETE CASCADE?
We have a CURSOR then we need BULK COLLECT?
What is the relation b/w view and trigger
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?
What is Overloading of procedures ?
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?
What are the PL/SQL Statements used in cursor processing ?
Delete duplicate records in the emp table.
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?
difference between table level constraint and column level and advantages of table level constraint