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
What is a constraint? Tell me about its various levels.
What is a memo field?
Which operator is used in query for pattern matching?
What is record variable?
What is the usage of when clause in trigger?
What is trigger in pl sql?
What are the basic sql commands?
What is the use of count (*) in sql?
Is sql procedural language?
What view means?
Explain locks? : Transact sql
Are pl sql variables case sensitive?
Explain how can you save or place your msg in a table?
What is column?
What is a pdo connection?