Answer Posted / ajit nayak

SELECT TO_CHAR(LAST_ANALYZED,'DD-MON-YYYY HH12:MI:SS'),COLUMN_NAME
FROM COLS
WHERE TABLE_NAME = 'EMP';

What is an oracle recycle bin?

551

---

Explain how you would restore a database using RMAN to Point in Time?

1638

---

How to create a table index?

568

---

What is define in oracle?

571

---

How to use an explicit cursor without open statements?

616

---

---

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

1570

---

Does oracle database need java?

523

---

What is oracle instant client?

566

---

Why is oracle database so popular?

566

---

how to make an oracle object

1859

---

How to convert times to characters in oracle?

609

---

How to connect ms access to oracle servers?

552

---

We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

4932

---

Can sub procedure/function be called recursively?

541

---

How would you go about verifying the network name that the local_listener is currently using?

1609

---