Answer Posted / satya krishna

B-TREE INDEX, BITMAP INDEX, REVERSE INDEX, FUNCTION-BASED INDEX, ASCENDING & DESCENDING INDEX, Cluster indexes, bitmap join indexes, text indexes, Hash cluster indexes, DOMAIN INDEXES.

Indexes are logically and physically independent of the data in the associated table.

ONCE AFTER CREATING THE INDEX ORACLE WILL AUTOMATICALLY HANDLE IT LATER.

How would you go about verifying the network name that the local_listener is currently using?

1602

---

How can windows applications connect to oracle servers?

520

---

Why does oracle 9i treat an empty string as null?

538

---

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1584

---

What is define in oracle?

565

---

---

What is the difference between sharding and partitioning?

501

---

What is data type in oracle?

558

---

How to use "in" parameter properly?

617

---

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

1771

---

How to loop through data rows in the implicit cursor?

539

---

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?

1968

---

Why we use bulk collect in oracle?

532

---

How to write a query with a right outer join in oracle?

613

---

What is a cursor and what are the steps need to be taken?

598

---

how to do daily transactions with out sql* loader control file regesterd in apps?

1221

---