type type_name is table of varchar2(30) index by
binary_integer
for the above type you have to create a identifier...
like
identifier_name type_name;
for the above type you can use the below methods..like
first , last , prior, next , delege..etc...like this..
if you create a cursor...like
cursor cursor_name is select * from scott.emp;
is there any methods like above to use prior, fist , last ,
next , trim ,etc...
- 1 Answers
- 6398 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / sagar
Hi,
When you are using this:
cursor cursor_name is select * from scott.emp;
you can use
record_name cursor_name%rectype;
But I think the methods you mentioned like prior, fist ,
last ,
next , trim ,etc...are not present here..(Iam not sure)
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is attribute indicator in pl sql?
How do you use join?
what is online transaction processing (oltp)? : Sql dba
what is schema? : Sql dba
How do I make sql search faster?
Is there a way to automate sql execution from the command-line, batch job or shell script?
How to write a query to show the details of a student from students table whose
What are the different types of tables in sql?
what is rdbms? : Sql dba
Does truncate need commit?
What is an example of translating a date into julian format?
Which is better join or subquery?
What is the use of sqldataadapter?
what are the advantages of mysql in comparison to oracle? : Sql dba
Explain how to use transactions efficiently : transact sql
