Answer / kishore

Sure,we can write bulk collect in triggers also.
Bulk Collect purpose is just to retrieve the multivalues of
attribute into a collection(like array,record,tables etc)

How do you select unique values in sql?

0 Answers  

---

can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)

5 Answers  

---

What does “select count(*) from tab” result?

15 Answers   IBM, Student, Wipro,

---

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,

---

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE, Its some urgent requirement ,thanks in advance

6 Answers  

---

Can we join tables without foreign key?

0 Answers  

---

How can I make sql query run faster?

0 Answers  

---

Does it possible to pass object (or) table as an argument to a remote procedure?

1 Answers   TCS,

---

What are the benefits of pl/sql packages?

0 Answers  

---

Which one is better sql or oracle?

0 Answers  

---

What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?

6 Answers   Saama Tech,

---

i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87964579,156678,678900876) that means if i select phone no from table i want to get total count of phone numbers i.e 6

8 Answers   Satyam,

---