Why does %isopen return false for an implicit cursor?
Answer / kiran r
In Case of Implicit Cursor. it returns always false because the cursor automatically closes once it is Executed
| Is This Answer Correct ? | 0 Yes | 0 No |
Is sql a scripting language?
What is cross join example?
What are the different types of joins and explain them briefly.
How do I view stored procedures?
what is meant by DML?
Why do we use joins?
Why are cursors used?
table :- city name country code abc 11 bcd 22 cde 232 def 33 write a procedure , so that when we give a phone no. eg - 1123456789 - o/p sud be city name = abc if phone no. - 2322345897 , o/p sud be =cde note - bcd and cde city name sud be diff. as dey diff only with th last no. Pls ans. this questnion.
What does dml mean?
i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?
how to create object in plsql
What is data type in sql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)