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

can we use out parameter in a function?Give an example.

4 Answers   TCS, Logica CMG,

how do u call in & out parameters for stored procedures?

10 Answers   TCS, A1 Technology, Techicon,

What are wait events. Describe the wait event tables.

1 Answers   CTS,

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

3 Answers   Cap Gemini, IBM,

How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)

3 Answers   TCS,

what is difference between decode and case function?

2 Answers  

How can u find column name from a table which have max value in a row.( not max value)

5 Answers  

Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F

5 Answers   IBM,

write sub query for eliminating duplicate rows using analytical function?

3 Answers   Metric Stream,

How to display all Friday's in a year with date?

3 Answers   Flipkart,

How pl/sql source code can be protected?

2 Answers  

can i write pl/sql code in a package

2 Answers