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
- 6389 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
How can you load microsoft excel data into oracle? : aql loader
What is acid property in a database?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
What are the key differences between SQL and PL SQL?
What is difference between stored procedures and application procedures?
How many types of index are there?
How do we use distinct statement? What is its use?
What is the primary use of normalization?
What is audit logout in sql profiler?
How does sql developer connect to oracle database?
write an sql query to find names of employee start with 'a'? : Sql dba
Which sorts rows in sql?
How to revise and re-run the last sql command?
Is primary key a clustered index?
Can we use the cursor's to create the collection in PL/SQL?
