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
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
Mention what are different methods to trace the pl/sql code?
What is the difference between jpql and sql?
what is column? : Sql dba
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
How does join work in sql?
what is a primary key? : Sql dba
What is nosql db?
When should I use nosql database?
What is time based sql injection?
What are % type and % rowtype?
what are the advantages of sql ? : Sql dba
Which tcp/ip port does sql server run?
what are the advantages and disadvantages of views in a database? : Sql dba
What is pl sql in dbms?
