Answer Posted / nageswararao.k

procedures and functions are subprograms but triggre is not
a subprogram.
procedure:--once we create a procedure we can use that
procedure from any pl/sql block and any front end
application like java,.net applications.no need to execute
every time.
function:----using function ,we can reuse the code and
passed values though perameteres from calling function to
declared function.

What is Redo Log Buffer in Oracle?

1141

---

How data locks are respected in oracle?

1015

---

What is execute immediate in oracle?

959

---

How to set up autotrace for a user account?

986

---

What is key preserved table?

969

---

How to list all tables in your schema?

994

---

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2214

---

What is oracle latest version?

1044

---

What is the difference between I and G in Oracle?

1025

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2071

---

What is Segment Advisor in Oracle?

1055

---

How can we delete duplicate rows in a table?

936

---

1) Does oracle have any table which contain all the exceptions and it's code internally?

1709

---

What is an oracle data file?

1047

---

What is a parameter file in oracle?

1060

---