Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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...

Question Posted / sweetsarao


type type_name is table of varchar2(30) index by binary_integer for the above type you have to cr..

Answer / 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

More SQL PLSQL Interview Questions

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for example emp id =5, repeated in two times in rows same id how to delete same empid please any one of the write query send in my id

8 Answers   CGCI,

How do I install sql?

0 Answers  

Does access use sql?

0 Answers  

What is the most restrictive isolation level? : Transact sql

0 Answers  

How to pipe multiline string to isql?

0 Answers  

How do I make sql search faster?

0 Answers  

i have a table t1 a math 20 b phy 30 cchemisty 10 a math 40 b phy 23 c che 21 a math15 bphy 33 c che 56 write a quire to find out the max markr of each subject

8 Answers  

Which is better join or inner query?

0 Answers  

how many columns can be used for creating index? : Sql dba

0 Answers  

How can I tell if sql is running?

0 Answers  

Why do we use cursors?

0 Answers  

how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900

8 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories