Answer Posted / ashutosh

Schema is a collection of user defined objects such as
(table,view,procudure,etc..)

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4016

---

Does oracle charge for java?

590

---

Explain the use of grant option in imp command.

578

---

Describe the types of sub query?

552

---

What is catalog in Oracle?

649

---

---

How to define a data field as not null?

631

---

How to create a table in a specific tablespace?

543

---

How is it different from a normal table?

582

---

How to update values in a table in oracle?

579

---

What is key preserved table?

562

---

Where do we use decode and case statements?

559

---

defination of bitmap index

1624

---

How to retrieve the count of updated rows?

576

---

Explain the function of optimizer in oracle?

596

---

How to call a stored function with parameters?

564

---