Answer / rabiya basri

Answer -> SELECT statement, cursors.

Answer / srilekha

using select stmt and cursor u can retrive the records

Answer / prasad

two methods of retrieving SQL are
1) is select stmt
2) is cursor
we can use these commands to retrive the related records

Answer / ashvin ranpariya

two methods of retrieving SQL is
1) Select Statment
Example: select * from XYZTBLES;
2)Cursor
Example:

declare
type r_cursor is REF CURSOR;
c_emp r_cursor;
en emp.ename%type;
begin
open c_emp for select ename from emp;
loop
fetch c_emp into en;
exit when c_emp%notfound;
dbms_output.put_line(en);
end loop;
close c_emp;
end;

Answer / neeraj pawar

select
&
Cursor

Answer / sudipta ku dhal

1)select
2)cursor

Answer / guest

1.PROJECTION
2.SELECTTION

What is Highwatermark?

3 Answers   Thermotech,

What is the main reason behind using an index?

0 Answers  

how can I make a script that can be bi-language (supports english, german)? : Sql dba

0 Answers  

What is primary key in db?

0 Answers  

What is ON DELETE CASCADE?

3 Answers  

Is join an inner join?

0 Answers  

What is Difference Between Unique and Primary Key Constraints?

0 Answers   Wipro,

How can I create a table from another table without copying any values from the old table?

8 Answers  

Does oracle use sql?

0 Answers  

What is left join in postgresql?

0 Answers  

function can return value ,procedure also return value through out parameter then what is the difference?

3 Answers   3i Infotech,

What is the Query to print out the individual total number of duplicate row in sql.

5 Answers   TCS,