Two Methods of retrieving SQL?

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

More SQL PLSQL Interview Questions

Mention what are different methods to trace the pl/sql code?

0 Answers  


How can I tell if sql is running?

0 Answers  


What does subquery mean in sql?

0 Answers  


What is sql entity?

0 Answers  


Which is faster view or stored procedure?

0 Answers  






Can there be more than one function with a similar name in a pl/sql block?

0 Answers  


How to start oracle sql developer?

0 Answers  


How do I trace sql profiler?

0 Answers  


Explain what is table in a database?

0 Answers  


How do I install sql?

0 Answers  


How to install oracle sql developer?

0 Answers  


What is auto increment?

0 Answers  


Categories