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 is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

906

---

Does truncate need commit?

890

---

What is the difference between join and natural join?

880

---

How do I truncate a sql log file?

1002

---

What is query syntax?

912

---

What is a natural join sql?

919

---

What is the difference between sql and mysql?

1050

---

What are the types of optimization?

886

---

What are the types of join in sql?

1026

---

What is 19 null in sql?

894

---

How many types of literals are available in pl sql?

1044

---

What are predefined functions in sql?

976

---

What is a schema sql?

1051

---

Which is faster union or join?

899

---

What are all types of user defined functions?

1004

---