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 |
Can I call a procedure inside a function?
Explain the significance of the & and && operators in pl sql.
i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.
What is an emotional trigger?
Which table is left in left join?
What are stored procedures in mysql?
What is the difference between count 1 and count (*) in a sql query?
Is sql injection illegal?
What is sql not null constraint?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
When is the explicit cursor used ?
Is subquery faster than join?