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;

Define SQL and state the differences between SQL and other conventional programming Languages?

1206

---

Explain commit, rollback and savepoint.

989

---

Does sql view stored data?

949

---

Can we insert delete data in view?

944

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1592

---

How to read/write files from pl/sql?

1033

---

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1092

---

What is write ahead logging in sql server?

1042

---

Explain the components of sql?

1053

---

Is crud a cuss word?

1028

---

What is the difference between clustered and non-clustered index in sql?

1009

---

What is interval partition?

1051

---

Which is the correct statement about truncate and delete?

1104

---

Why is sql*loader direct path so fast?

1099

---

Define sql delete statement.

1003

---