Answer Posted / nageswararao.k

procedure and functions both are subprogrames.but trigger
is not a subprogram
procedure:--a procedure is created to perform one or more
DML operations.if we create procedure,then we can call the
procedure from any frontend application and any pl/sql
block.
procedures may or may not return a value .
we can not call procedure from select statement.
in procedure the out perameter return a value.


function:-the functions are created to do calculatiions and
computations.
function access some input and perform a task and must
return a value.the value return by return statement.
we can call the function from select statement.

How to find out what oracle odbc drivers are installed?

983

---

What is Undo Management Advisor in Oracle?

1045

---

What is catalog in Oracle?

1282

---

How to assign values to data fields in record variables?

979

---

What is the difference between alert log file and tarce file ?

2106

---

What is dual table oracle?

932

---

What privilege is needed for a user to create views in oracle?

988

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2053

---

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5343

---

How to start a specific oracle instance?

997

---

How to manage transaction isolation level?

955

---

What is translate in oracle?

1053

---

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2136

---

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.

1710

---

Explain oracle insert into command?

1063

---