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

Explain the use of indexes option in exp command.

1086

---

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

2146

---

What is program global area (pga) in oracle?

981

---

What is a trigger and what are its types in oracle?

1022

---

What are the uses of synonyms?

1099

---

What is integrity and what is constraint??Explain with example

2231

---

What are the numeric comparison operations?

1071

---

Can you tell me how to add new column in existing views?how?How is possible?

1391

---

What language does oracle use?

1061

---

How to create a new view in oracle?

1024

---

What is the difference between a hot backup and a cold backup in oracle?

972

---

What are the four Oracle system processes that must always be up and running for the database to be useable?

968

---

How to execute the package in oracle?

1053

---

Is a rollback possible to any savepoint?

1023

---

What is tns name?

934

---