Answer / Amar Gupta

"To spool a CSV formatted file in SQLPLUS, use the following command: `SPOOLOFF` (to turn off spooling) and then create a new file with `SPFILE <filename> SET TERMOUT OFF`; after executing your query, you can redirect output to the created file using `SPool <filename>.csv`. For formatting CSV, use `CHR(10)` for line breaks. Here's an example:
```sqln
SPOFF;n
SPFILE myfile SET TERMOUT OFF;n
SELECT column1 || ',' || CHR(10) || column2 || ',' || CHR(10) FROM your_table;n
SPOOL myfile.csv;"

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

1 Answers  

---

What is analyze command used for?

1 Answers  

---

What is the minimum client footprint required to connect c# to an oracle database?

1 Answers  

---

Define 'view' advantage ?

2 Answers   AZTEC, TCS,

---

when a grant option is encountered for a table EMP to a peer sitting beside you who has already having the table of that name (EMP), then what is the result?

2 Answers  

---

What privilege is needed for a user to create views in oracle?

1 Answers  

---

How to get the Installed Oracle Version Information ?

1 Answers   MCN Solutions,

---

What are data pump export and import modes?

1 Answers  

---

How to calculate date and time differences in oracle?

1 Answers  

---

Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

1 Answers  

---

structural difference between bitmap and btree index ?

1 Answers   Infosys,

---

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1 Answers  

---