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 |
Why truncate is used in sql?
Can you alter start with clause?
Why do we need sharding?
how to debugg a procedure or package using dbms_output.put_line in plsql
sales persons should always receive commission of 100 at least. employees who r not sales persons should never receive commission.(Triggers)
display your age in months?
What is the use of a view in sql?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What is replication id?
What is normalization ?
9 Answers BirlaSoft, CTS, HCL,
what is autonomouse transaction?
Can we insert delete data in view?