Answer Posted / pallavi
cursor is a mechanism by which we can assign a name to a select statement and manipulate the information within sql statement
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What are statistics, under what circumstances they go out of date, how do you update them?
which background process invoke at the time of upgradation tell me???
what is the last version,the release date of that version and fix pack of ibm db2 udb?
how can you connect from 10g user to 11g user??
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
Why does Oracle not permit the use of PCTUSED with indexes?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What is a correlated sub-query? : sql server DBA
What are the recovery models for a database? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
How would you best determine why your MVIEW couldn't FAST REFRESH?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?