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;

What schema means?

521

---

What are the different types of database management systems?

530

---

What is a table partition?

591

---

what is blob? : Sql dba

560

---

what is union, minus and interact commands? : Sql dba

657

---

---

Can sql function call stored procedure?

556

---

What is dense_rank?

536

---

Does view store data in sql?

530

---

What is a pl/sql block?

590

---

What is difference between stored procedure and trigger?

529

---

What is data type in sql?

554

---

Is foreign key mandatory?

554

---

Is pl sql useful?

537

---

what is a database lock ? : Sql dba

589

---

what are ddl statements in mysql? : Sql dba

577

---