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;

Is sqlite free?

918

---

Does sql between include endpoints?

957

---

What is database white box testing and black box testing?

1055

---

What is native sql query?

976

---

Is primary key is clustered index?

955

---

What is the difference between microsoft access and sql server?

997

---

How do you delete data from a table?

981

---

What is the difference between in and between in sql?

1005

---

What is ttitle and btitle?

1018

---

What do you understand by pl/sql packages?

1026

---

How to get list of all tables from a database?

1113

---

Is sql developer case sensitive?

947

---

How many times can we commit in a loop?

966

---

What is percent sign in sql?

1227

---

what are properties of a transaction? : Sql dba

1037

---