What are the datatypes available in pl/sql ?

0 Answers  

---

A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.

2 Answers   TCS,

---

Can we write dml inside a function in sql server?

0 Answers  

---

what are string data types? : Sql dba

0 Answers  

---

What is the difference between truncate and drop statements?

0 Answers  

---

---

how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900

8 Answers  

---

Explain the savepoint statement.

0 Answers  

---

Do stored procedures prevent sql injection?

0 Answers  

---

what is Complex index. how to create it?

2 Answers  

---

mail-id table contains two columns(email_id,userid) it contains different types of mail-ids,and no of users. here username length is differ na,(ex- tamil@yahoo.com,joshua@hotmail.com like) now i want to fetch the email-ids only starting from '@' (ex-@gmail.com,@yahoo.com,@hotmail.com

5 Answers  

---

Can we commit inside a trigger?

0 Answers  

---

what are pl/sql collections?

4 Answers   JPMorgan Chase, Oracle,

---