Answer Posted / 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;

how many ways we can we find the current date using mysql? : Sql dba

1144

---

What are the built in functions of sql?

1092

---

How do I save a stored procedure?

1067

---

What does desc stand for?

1122

---

What is use of term?

1126

---

Explain the advantages and disadvantages of stored procedure?

1198

---

Does execute immediate commit?

1289

---

what is the difference between a web-garden and a web-farm? : Sql dba

1139

---

What does data normalization mean?

1028

---

explain the options of myisamchk to improve the performance of a table. : Sql dba

1072

---

what is column? : Sql dba

1050

---

What is trigger and types?

1069

---

How bulk collect improves performance?

1055

---

What is a mutating table and a constraining table?

1178

---

Explain how exception handling is done in advance pl/sql?

1045

---