Answer / hitendra yadav

(1) Simple table store in the database as a object but
PL/SQL or index by table does not store in the database it
can be create only in PL/SQL block.
(2) Simple table in the database can have more then
multiple column up to 254 but index by table can only have
two column first is primary key column of BINARY_INTEGER
and second column is any collection type column.

Answer / heena

pl/sql tables are not store in database but normal pl/sql
tables are stored in database

Table name: T1, it has only one column. col1 ------ c b a b b b b d s a a t s Requirement: I need the following output from the above base table by using SQL query. col1 Cnt ----- ------- a 3 b 5 Others 5 Please help. Thanks Guru v.gurus@in.com

11 Answers  

---

What can I use instead of union in sql?

0 Answers  

---

What is data type in sql?

0 Answers  

---

If records are inserted into table without committing.How to refer to these values in a procedure?

2 Answers  

---

What are pl/sql exceptions? Tell me any three.

1 Answers  

---

---

how i do the database testing of online money transactions between two parties (client and organization). suppose our company makes a website for our client and give a extra feature of online money transaction with there clients then how i test this feature in database testing

1 Answers  

---

what is meant by DML?

5 Answers   HCL,

---

How do I run sql profiler?

0 Answers  

---

Explain correlated query work?

0 Answers  

---

Which normal form is best?

0 Answers  

---

Difference between truncate, delete and drop commands?

0 Answers  

---

Is sql a microsoft product?

0 Answers  

---