Answer Posted / mohsin mohammed abdul
Cursors are the private memory area in the SGA. they store
the result set of a query. And they are used to fetch
multiple rows from the tables in the pl/sql block
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How to choose all records from the table?
Data table as parameter in sql server?
How to start sql server browser service?
How to make a column nullable?
Does hive support indexing?
What are a scheduled jobs?
How to define the name and server for a new dsn?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
What are clustered and non-clustered index?
Write a SQL query to delete a table?
How to create a large table with random data for index testing in ms sql server?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Where is trigger in sql server?
Explain transaction server distributed transaction?
How can I check that whether automatic statistic update is enabled or not?
