why we use cursors

Question Posted / nagaraju1

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

More DB Administration Interview Questions

deleted of control file how will u recover control file?

What column differentiates the V$ views to the GV$ views and how?

why do we give pctfree and pctused in create table statement?

Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

how to restore files with rman?

how can you connect from 10g user to 11g user??

If we issue alter database begin backup. What happens to database?

Name two files used for network connection to a database.

How would you extract DDL of a table without using a GUI tool?

Hot backup procedure?

What is the difference between the SQL Loader and IMPORT utilities?

For more DB Administration Interview Questions Click Here