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
- 2519 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
How do I remove duplicates in two columns?
Does group by remove duplicates?
what are all the common sql function? : Sql dba
Can we rollback truncate?
what are aggregate and scalar functions? : Sql dba
Can we use distinct and group by together?
Is primary key clustered index?
Do we need to rebuild index after truncate?
define sql insert statement ? : Sql dba
Is inner join faster than left join?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
what is collation? : Sql dba
what is sql server agent? : Sql dba
Is primary key always clustered index?
What is the current version of sql?
