why we use cursors
Answer / 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 |
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
How would you go about verifying the network name that the local_listener is currently using?
What is a system database and what is a user database? : sql server DBA
who owns the operating system files created by the utl_file package?
how can you initialize log miner?
From the database level, how can you tell under which time zone a database is operating?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What is a correlated sub-query? : sql server DBA
Give the two types of tables involved in producing a star schema and the type of data theyhold.
What is the difference between LMT & DLT?
orra 1555 what is this error,why it is occur?
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