difference between oracle 8i and oracle 9i

8 Answers  

---

Which command is used to delete a package?

0 Answers  

---

How do I find sql profiler?

0 Answers  

---

What is error ora-12154: tns:could not resolve the connect identifier specified?

0 Answers  

---

How do you declare a user-defined exception?

0 Answers  

---

---

Explain the uses of a database trigger?

0 Answers  

---

What is a schema? How is it useful in sql servers?

0 Answers  

---

what is the difference between delete and truncate commands? : Sql dba

0 Answers  

---

Can we insert data into view?

0 Answers  

---

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

---

How do you exit in sql?

0 Answers  

---

i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that.example jan has 4 weeks i need 1st dd for evry wk

1 Answers   Aspire,

---