Answer Posted / karthik

In SQL Prompt:
-------------
set lines 100 pages 100;
set colsep"|"
spool c:\Datas.xls;
select * from emp
/
spool off;

In Excel Sheet, use Text to Column->Delimeter to replace
the "|" pipe symbol

How to change user password in oracle?

1021

---

How oracle handles dead locks?

1064

---

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)

2316

---

What happens to the current transaction if a ddl statement is executed?

1006

---

Please explain compound trigger in oracle?

1051

---

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2250

---

When do you get a .pll extension in oracle?

1142

---

What are the attributes of the cursor?

995

---

What is an oracle user account?

980

---

How do I recompile a procedure in oracle?

955

---

what is the dual table in oracle?

987

---

How to pass parameters to procedures in oracle?

1037

---

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2333

---

What is meant by joins?

1054

---

Hi Can any one tell me what are the API's used in requisition import.

1917

---