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

Why are cursors used?

0 Answers  

How to Execute a Package in PL/SQL.?

0 Answers   MCN Solutions,

a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

0 Answers   TCS,

How the execution will be done in exceptions?

2 Answers  

Can we update views in sql?

0 Answers  

How do I remove duplicates in two columns?

0 Answers  

Why functions are used in sql?

0 Answers  

What is sqlcommand?

0 Answers  

What are the steps you take to tune(performance tuning) the code in plsql?

4 Answers   Cap Gemini, Infosys, TCS,

Explain what is table in a database?

0 Answers  

How does rowid help in running a query faster?

0 Answers  

Whis is not false in primary key?

0 Answers   Fintellix,