Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7354 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 your daily office routine?
What are the different type of joins in sql?
How would you reference column values before and after you have inserted and deleted triggers?
How do you remove duplicates without using distinct in sql?
How to rename a table?
What is sql table?
What is the difference between truncate and drop statements?
How does one load ebcdic data? : aql loader
Can we use joins in subquery?
what is myisam? : Sql dba
How do I use google cloud in sql?
define sql delete statement ? : Sql dba
What are different functions in sql?
Is and as keyword in pl sql?
Explain what is a column in a table?
