what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

0 Answers  

---

What is Referential Integrity?

3 Answers  

---

Write a query to find five highest salaries from EMP table. (there is a column SALARY)

24 Answers   Cap Gemini, iNautix,

---

If a View on a single base table is manipulated will the changes be reflected on the base table?

5 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,

---

What are packages in pl sql and also explain its advantages?

0 Answers  

---

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,

---

What is the order of sql select?

0 Answers  

---

what is innodb? : Sql dba

0 Answers  

---

how to fetch alternate records from a table? : Sql dba

0 Answers  

---

What is the difference between inner join and natural join?

0 Answers  

---

What are different methods to trace the pl/sql code?

0 Answers  

---