Interested to Buy Any Domain ? << Click Here >> for more details...
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...
- 1 Answers
- 2526 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / Richa Bansal
The methods you mentioned (first, last, prior, next, trim) are not applicable to Varrays or Index by tables. They are cursor-related functions in PL/SQL used for traversing the result set of a cursor.
To apply these functions to cursors, you can follow these steps:
1. Declare a cursor with SELECT statement.
2. Open the cursor using OPEN keyword.
3. Fetch rows from the cursor using FETCH statement or LOOP construct.
4. Use cursor manipulation functions like PRIOR, NEXT, LAST, and FIRST to navigate through the result set.
5. Close the cursor when done using CLOSE keyword.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is inner join faster than left join?
Can delete statement be rollbacked?
Do we need to rebuild index after truncate?
what is bcp? When does it used? : Sql dba
how to start mysql server? : Sql dba
what are all the common sql function? : Sql dba
How do I remove duplicates in two columns?
define sql insert statement ? : Sql dba
what is sql server agent? : Sql dba
what are the advantages of sql ? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
what is collation? : Sql dba
What is the current version of postgresql?
What is your daily office routine?
Can we use distinct and group by together?
