Two Methods of retrieving SQL?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / guest

7 Answers
56607 Views
Atiric Software, Microsoft, Oracle, TCS, Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Two Methods of retrieving SQL?..

Answer / rabiya basri

Answer -> SELECT statement, cursors.

Is This Answer Correct ?

207 Yes

11 No

Two Methods of retrieving SQL?..

Answer / srilekha

using select stmt and cursor u can retrive the records

Is This Answer Correct ?

127 Yes

6 No

Two Methods of retrieving SQL?..

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

Is This Answer Correct ?

62 Yes

8 No

Two Methods of retrieving SQL?..

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;

Is This Answer Correct ?

49 Yes

5 No

Two Methods of retrieving SQL?..

Answer / neeraj pawar

select
&
Cursor

Is This Answer Correct ?

18 Yes

2 No

Two Methods of retrieving SQL?..

Answer / sudipta ku dhal

1)select
2)cursor

Is This Answer Correct ?

17 Yes

3 No

Two Methods of retrieving SQL?..

Answer / guest

1.PROJECTION
2.SELECTTION

Is This Answer Correct ?

3 Yes

1 No

Post New Answer