ref cursor is a datatype we can assign variables that data type called curs

What is a REF CURSOR? Compare strong and week ref cursor types.

Question Posted / sure

6 Answers
28676 Views
I also Faced
E-Mail Answers

Answer Posted / sure

ref cursor is a datatype we can assign variables that data type called cursor variable,cursor variable can associate with different queries at run time,primary advantage of refcursor is we can pass result set morethan one sub program

Is This Answer Correct ?

8 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the rollback statement?

1006

What are procedures used for?

985

What is sqlcontext?

1081

How do I copy a table in sql?

987

What do you mean by rowid?

979

Explain what is rdbms?

1032

Does sql profiler affect performance?

987

What is difference between sql and oracle?

1127

What is a scalar value in sql?

1070

What programs use sql?

1002

Why do we use view in sql?

949

What is a null value?

1141

What is identity column in sql server?

1048

Explain the insert into statements in sql?

1005

What is constant in pl sql?

1021