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
can we use out parameter in a function?Give an example.
how do u call in & out parameters for stored procedures?
What are wait events. Describe the wait event tables.
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.
How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)
what is difference between decode and case function?
How can u find column name from a table which have max value in a row.( not max value)
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
write sub query for eliminating duplicate rows using analytical function?
How to display all Friday's in a year with date?
How pl/sql source code can be protected?
can i write pl/sql code in a package