Answer Posted / nivitha

select * from dba_users order by desc;

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)

2260

---

What is the maximum number of triggers that can be applied to a single table?

954

---

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?

972

---

Explain a data segment?

1015

---

When do you get a .pll extension in oracle? Explain its importance

985

---

Explain an extent?

1048

---

Difference between pre-select and pre-query

1027

---

What is the relationship among database, tablespace and data file?

926

---

What is the usage of analyze command in oracle?

1031

---

What is an oracle recycle bin?

929

---

What is the difference between translate and replace?

1010

---

How to add a new column to an existing table with a default value?

965

---

Give the constructs of a package, function or a procedure.

982

---

What is oracle instant client?

970

---

Is there any function in oracle similar like group_concat of mysql?

986

---