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
- 6547 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
Is sql harder than python?
What is sql dialect?
Why schema is used in sql?
What is the difference between left join and right join?
how to decrement dates by 1 in mysql? : Sql dba
What are %type and %rowtype for?
Explain the difference in execution of triggers and stored procedures?
What is $$ in sql?
what is 'mysqlcheck'? : Sql dba
differentiate between float and double. : Sql dba
What company owns postgresql?
What are the different types of tables in sql?
What is dba in sql? : SQL DBA
What are different joins used in sql?
What does rownum mean in sql?
