How to list all indexes in your schema?

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  

---

difference between imlicit cursor and explicit cursor ?

5 Answers   Cap Gemini,

---

How to delete a column in an existing table?

0 Answers  

---

What is rich query?

0 Answers  

---

What is Normalization ?

55 Answers   ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,

---

I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.

4 Answers  

---

When do I need to use a semicolon vs a slash in oracle sql?

0 Answers  

---

Explain the use of compress option in exp command.

0 Answers  

---

What is a trigger oracle?

0 Answers  

---

16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.

1 Answers   Wipro,

---

How can we create the complete backup of data in the oracle.

0 Answers   IPEC, Satyam, SunTec,

---