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;

Why do we use joins in sql?

970

---

What is insert command in sql?

1127

---

What is update query?

980

---

What is sql profiling in oracle?

1063

---

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

1081

---

what is sql profiler? : Sql dba

1041

---

What is the difference between clustered and non-clustered indexes?

1089

---

What are different sql data types?

1045

---

What is the difference between cross join and natural join?

1020

---

What are the features of pl sql?

1067

---

What is replication id?

935

---

How much does sqlite cost?

1035

---

What type of database is cloud sql?

1100

---

How delete all data from table in sql?

1015

---

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1187

---