Answer Posted / nagaraju

We have mainly two different indexes .

Implicit index and Explicit index.

Explicit indexes are again of many types like
simple index,unique index,Bitmap index,Functional
index,Organisational index,cluster index.

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4415

---

what is a Nested Loop join?

2176

---

What is a read only transaction in oracle?

1081

---

What is the difference between alert log file and tarce file ?

2233

---

Describe an oracle table?

1101

---

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

2093

---

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2231

---

State and explain about oracle instance?

1053

---

What types of joins are used in writing subqueries?

1033

---

How to rename an existing table?

1220

---

How to convert character types to numeric types?

1193

---

Is java required for oracle client?

1049

---

How to use like conditions in oracle?

1115

---

Can you tell me how to add new column in existing views?how?How is possible?

1516

---

Give the constructs of a package, function or a procedure.

1098

---