Answer Posted / test

Index simply means sorting of data. Let u stake an example :

EmpID Name
1 A
6 B
5 C
9 D
...
...
2 ZZ

Now if we create index (Talking about btree index) on EmpId
it means creating a segment with the following in sorted
order
EmpId Rowid
1 <some value>
2 ....
5 ...
6 ...
...

Now if we want to search with EmpId, it will do a binary
search and get the rowid in few searches

How to retrieve the count of updated rows?

1137

---

Why does Oracle not permit the use of PCTUSED with indexes?

2429

---

How to invoke the data pump import utility?

1179

---

How can I create database in oracle?

1036

---

What is difference between cartesian join and cross join?

1103

---

List the types of joins used in writing subqueries?

998

---

what is the dual table in oracle?

1005

---

How to create a new table by selecting rows from another table?

1109

---

How to view existing locks on the database?

1058

---

> 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?

2040

---

What is the difference between post-database commit and post-form commit?

1210

---

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2333

---

What is logical backup in oracle?

1025

---

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2836

---

What is a proxy object?

1075

---