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 a bitmap index?
What is the basic structure of PL/SQL ?
What is Referential Integrity?
what is oracle sql,pl/sql with interfaces
How to find the count of letter "L" in HELLO
HP Interview -2016 Unix 1) grep command in unix 2) what is set command
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 : email@example.com thnx advance
how to create object in plsql
Maximum how many triggers can we use in trigger and How to find out how many records it fetched.
Could you please provide oca (oracle 10g) dumps for my certification ?
what is sql optimization
What is Temp Table and type of temp table?