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 happens to the current transaction if a ddl statement is executed?

949

---

Explain what are the type of synonyms?

1053

---

Is there an oracle sql query that aggregates multiple rows into one row?

930

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

971

---

How to install oracle database 10g xe?

962

---

Why do we need integrity constraints in a database?

969

---

How to fetch the row which has the max value for a column?

944

---

How to store only time; not date and time?

957

---

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2899

---

How to shutdown your 10g xe server?

1081

---

What are the ways tablespaces can be managed and how do they differ?

2267

---

How to convert csv to table in oracle?

920

---

What are the four Oracle system processes that must always be up and running for the database to be useable?

953

---

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2257

---

Can we save images in a database and if yes, how?

999

---