Cursor is Static REF Cursor is Dynamic

What are the Diff B/W Cursor and REF Cursor

Question Posted / guest

Answer Posted / guest

Cursor is Static
REF Cursor is Dynamic

Is This Answer Correct ?

10 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is rank function in sql?

1031

Can there be 2 primary keys in a table?

998

what is the difference between clustered and non clustered index in sql? : Sql dba

1130

what is data control language? : Sql dba

1030

What is the main difference between sql and pl/sql?

1102

What is date functions?

1035

Which one is better sql or oracle?

973

What is difference between procedure and trigger?

984

What are the different types of sql commands?

1128

Explain what is a database?

1088

What are different types of sql commands?

1119

what is the use of set statement in tsql? : Transact sql

1011

How do I partition a table in sql?

1137

What is the difference between left and left outer join?

949

Is trigger a stored procedure?

938