1. is it possible to use the cursor atttibutes (%found ,%
rowcount , %isopen , %notfound ) to our user defined cursor
names .......
cursor cursor_name is select * from scott.emp
if you use...
cursor_name%found , %rowcount ,%isopen,%notfound...will it
work...
--------------------------
2.what is the difference between the varray and index by
table ..
--------
3.
type type_name is table of number(8,3)
index by binary_integer;
identifier_name type_name;
first , last , prior , next ,trim are the methods we can
use it for the above type...simillary is there any way to
apply for cursors...
with thanks and regards..sarao...
No Answer is Posted For this Question
Be the First to Post Answer
Give which cursor is better for better performance means type of cursors?
What do you understand by pl/sql cursors?
what is the difference between pragma exception_init and raise_application_error
1 Answers Aetins, State Street,
How does one load ebcdic data? : aql loader
Does a user_objects view have an entry for a trigger?
can we write stored function in out parameters? how to call through select statement? how to written more than one value plz give the exmple?
Why primary key is required?
While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?
What is execution plan in sql?
Define concurrency control. : Transact sql
Why do we create views in sql?
Can we create clustered index without primary key?
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)