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 create a menu in sqlplus or pl/sql?

0 Answers  

What are the parameter modes supported by pl/sql?

0 Answers  

What types of commands can be executed in sql*plus?

0 Answers  

What is the difference between Union and Union all. Which is faster.

0 Answers  

How would you reference column values before and after you have inserted and deleted triggers?

0 Answers  




When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

0 Answers  

What are types of indexes in sql?

0 Answers  

Why use subqueries instead of joins?

0 Answers  

what is a sub query?how will you calculate working days in a month using sub query?

4 Answers   InteQ,

SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 Answers  

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

0 Answers  

What are literals in sql server?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories