How do you use collections in procedure to return the resultset?

0 Answers  

---

how to achieve this problem?i am having table with two colums like empno,gender. in gender column, i am having records male,female like that .my final output will be male female 5 6

4 Answers   Hexaware,

---

What is diff between bulk collect and forall

3 Answers   Metric Stream,

---

How exception handling is done in advance pl/sql?

0 Answers  

---

What is clustered and nonclustered index in sql?

0 Answers  

---

How does rowid help in running a query faster?

0 Answers  

---

What is error ora-01000: maximum open cursors exceeded

0 Answers  

---

How collections are improve the performance?

1 Answers   Polaris,

---

what is the sql query to display current date? : Sql dba

1 Answers  

---

Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)

1 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  

---

What can you do with pl sql?

0 Answers  

---