How do you modify a trigger?

0 Answers  

---

7. Where would you look for errors from the database design?

1 Answers   Fintellix,

---

The select into statement is most often used to create backup copies of tables or for archiving records?

0 Answers  

---

How to add, remove, modify users using sql?

0 Answers  

---

Does truncate remove indexes?

0 Answers  

---

---

What is difference between TRUNCATE & DELETE?

16 Answers   Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,

---

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,

---

How to execute OS(operating system) command from pl/sql?

3 Answers  

---

Why cross join is used?

0 Answers  

---

What are the syntax and use of the coalesce function?

0 Answers  

---

what is a view? : Sql dba

0 Answers  

---

write sub query for eliminating duplicate rows using analytical function?

3 Answers   Metric Stream,

---