Two Methods of retrieving SQL?
Answers were Sorted based on User's Feedback
Answer / srilekha
using select stmt and cursor u can retrive the records
Is This Answer Correct ? | 127 Yes | 6 No |
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 |
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 |
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
What are the operators used in select statements?
What are few of the schema objects that are created using PL/SQL?
What does select top 1 do in sql?
what is the difference between clustered and non clustered index in sql? : Sql dba
What is the use of triggers?
explain the delete statements in sql
What are the advantages of normalization?
What is PL/SQL Records?
What is delete command in sql?
How many rows can sqlite handle?
can i create trigger on synonym is it possible or not please help me