Answer / orawhiz

Each Index has an Index segment that stores all of its data

Answer / nishi

Oracle creates the index segment for an index or an index partition when you issue the CREATE INDEX statement. In this statement, you can specify storage parameters for the extents of the index segment and a tablespace in which to create the index segment.

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

0 Answers   Oracle,

---

How to load data from external tables to regular tables?

0 Answers  

---

> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

0 Answers  

---

State and explain the different types of data models?

0 Answers  

---

What does a Control file Contain ?

2 Answers  

---

How to update values on multiple rows in oracle?

0 Answers  

---

What is a dynamic performance view in oracle?

0 Answers  

---

what is view?

7 Answers   Accenture,

---

6. Display the client name and order date for all orders using the traditional method.

0 Answers   Wipro,

---

What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)

3 Answers  

---

difference between procedures and function?

7 Answers   IBM,

---

how to hide the stored procedure inside a package

1 Answers  

---