Answer Posted / madhuri
We can create cursor with parameters using parameterized
cursors.We declare the cursor in the deceleration section
with parameters.
Syntax: cursor <cursor_name>(parameters) is <select_stmt>
We pass values to these cursors while opening it.
open c1(100,'Computers');
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many columns should be in an index?
What is exit statement?
How many sql core licenses do I need?
Which normal form is best?
What do you mean by table in sql?
Can we commit inside a trigger?
Can we join same table in sql?
What does fetching a cursor do?
What is microsoft t sql?
What is mutating table error?
What is sqlite format?
How can you tell the difference between an index and a view?
Explain scalar functions in sql?
What are the ways on commenting in a pl/sql code?
How do you add a column to a table?