Answer Posted / ramprasad.s

Hi

Indexes in oracle are to retrieve the data from the
database at a faster rate

bye
sun_ramprasad@yahoo.com

Explain the use of parfile option in exp command.

1138

---

What are temporal data types in oracle?

1167

---

How to convert times to characters in oracle?

1071

---

How to delete all rows a table in oracle?

1119

---

Explain the dml?

1051

---

Differentiate between pre-select and pre-query?

1153

---

Is there any function in oracle similar like group_concat of mysql?

1105

---

Explain integrity constraint?

1209

---

Explain the function of optimizer in oracle?

1197

---

What is oracle server autotrace in oracle?

1220

---

What is null value in oracle?

1157

---

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1473

---

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

2092

---

Explain the use of record length option in exp command.

1117

---

How to add another datafile to a tablespace?

1088

---