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 can you communicate with operating system files from oracle?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
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.
how can you connect from 10g user to 11g user??
what do you understand by flashback feature of oracle?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what do you understand by fine-grained auditing?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is transparent data encryption? : sql server DBA
What are the recovery models for a database? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
