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...
- 0 Answers
- 1926 Views
- Satyam, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
select sal from emp group by sal
What are inbuilt functions in sql?
What are different clauses used in sql?
Why do we need a foreign key?
What is a primary key sql?
how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c
What is an Integrity Constraint?
If we declare constraints Unique and Not null on a single column then it will act as a Primary key, so what is the use of primary key??
what is a trigger in mysql? : Sql dba
What are basic techniques of indexing?
What operating systems are supported by oracle sql developer?
What is a database event trigger?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
