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

What is the difference between translate and replace?

1010

---

What is a server parameter file in oracle?

1000

---

How can you use check constraints for self referential integrity?

912

---

Compare and contrast between sql and sql server and explain its various functions?

913

---

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2147

---

Explain joins in oracle?

976

---

How would you change old and new values in an insert, delete and update triggers?

950

---

Explain a private synonyms?

980

---

What are advantages of dateset in datastage?

2197

---

Is it possible to split the print reviewer into more than one region ?

2221

---

How to shutdown your 10g xe server from command line?

1013

---

How to update a table row with a record?

959

---

What is Redo Log Buffer in Oracle?

1118

---

How to assign values to variables?

1042

---

What are the differences between blob and clob in oracle?

1028

---