Answer Posted / umapathy.r

WHEN-IMAGE-PRESSED
WHEN-IMAGE-ACTIVATED

how can we store any pdf file in oracle

2164

---

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

2030

---

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

4366

---

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.

1424

---

What is object data modeling?

963

---

What is not equal to in oracle?

1001

---

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2322

---

How to create a table interactively?

1088

---

When do you get a .pll extension in oracle?

1145

---

what is IDE,DMV in sql server?

2818

---

How to write text literals in oracle?

1067

---

How to define an anonymous procedure without variables?

1106

---

What is hot backup and logical backup?

1051

---

What is oracle datasource?

984

---

Is it possible to insert comments into sql statements return in the data model editor ?

2557

---