why pl sql doesn't support retrieving multiple records
Answer / rahul
pl/sql supports retriving multiple records but u need to
use of cursors. using cursor you can retrieve multiple
records.
| Is This Answer Correct ? | 24 Yes | 3 No |
Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)
How many types of synonyms in Oracle?
How to speed up webrick?
Give the different types of rollback segments.
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
candidate key is subset of super key but not vice-verse explain
what is meant by magic query
What do you mean by group by clause?
find out the second highest salary?
55 Answers Cognizant, Nucsoft, Oracle, TCS, Wondersoft,
how can db_files > maxdatafiles since db_files is for instance and the later is for database
I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!