Answer Posted / vsubbaiah

Implicit : Every SQL Statement performed as implicit cursor. Ex: Select * from Emp where empno = 7839 This is query automatically open the cursor and fetch the record getting the output of that record.

Explicit : In PLSql Block in we declare on declaration section we declare with name and select statement. In executable block we call the cursor and fetch the records more the one. For Ex : Declare
cursor c1 is select * from emp
getemp c1%rowtype;
begin
open c1;
loop
fetch c1 into getemp;
dbms_output.put_line (c1.col list);
end loop;
close c1;
end; This is explicit cursor

What is a private synonym?

1537

---

How to check the oracle tns settings?

1000

---

What are the limitations oracle database 10g xe?

989

---

Explain the dml?

928

---

What is the difference between sharding and replication?

975

---

What is set operator oracle?

934

---

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1717

---

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1007

---

What privilege is needed for a user to insert rows to tables in another schema?

965

---

What is the data type of dual table?

928

---

How can we find out the current date and time in oracle?

1046

---

What is a package ? What are the advantages of package ?

1040

---

Explain the difference between replace() and translate() functions in oracle?

986

---

What is meant by recursive hints in oracle?

1042

---

How to export data with a field delimiter?

980

---