Answer Posted / kumar swamy naidu

1.implicit

2.explicit
2.1.simple/b+tree index
2.2.bitmap index
2.3.reserved key index
2.3.composite index
2.4.function based index
2.5.partition index
2.6.domain index
2.7.text index
2.8.cluster index

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

3331

---

Whats the benefit of dbms_stats over analyze?

2003

---

Explain oracle 12c new features for developers?

1059

---

How to use regular expression in pattern match conditions in oracle?

1041

---

What are the different pseudo commands? Explain in general?

1080

---

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2462

---

What are the four Oracle system processes that must always be up and running for the database to be useable?

1018

---

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1051

---

Is oracle a programming language?

990

---

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2265

---

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2314

---

What privilege is needed for a user to insert rows to tables in another schema?

1015

---

How to connect asp pages to oracle servers?

1072

---

Is oracle the best database?

964

---

What is merge in oracle?

1054

---