Answer Posted / rushi

select ename from employee where sal=(select disinct(max(sal) from employee));

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)

2262

---

Explain constraining triggers.

1045

---

can u plz provide me oca sql dumps please i need them

1900

---

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2090

---

Design database draw er diagram for a certain scenario ?

4529

---

What are a collation and state the different types of collation sensitivity?

1095

---

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1060

---

Explain cascading triggers.

1013

---

does the query needs a hint to access a materialized view?

1817

---

Whats the benefit of dbms_stats over analyze?

1935

---

How to invoke the original export import utilities?

977

---

What are the roles of dba?

1020

---

Give the various exception types.

949

---

What is proxy method?

931

---

How to get last row id?

941

---