Top "Spool" questions

Using Spool in Oracle 11g

I want to use spool functionality in Oracle 11g. I want the entire output to be spooled into a file …

oracle oracle11g spool

SQL Oracle - How to save the query output with spool on a text file?

I'm using spool to save the output of my query into a text file but what is actually doing is …

text save output spool

How do i execute oracle Query using shell Scripting and send the results in the email

I am new to Unix scripting.. I have an oracle DB which has a username, password, hostname, port and servicename. …

sql oracle shell email spool

Adding a newline in a spool file

Is there a way to add a newline in an sql spool file? I need the file to be structured …

oracle sqlplus spool

What is the equivalent of the spool command in MySQL?

I know you use the spool command when you are trying to write a report to a file in Oracle …

mysql spool

Oracle Unicode Spooling

How can I spool data from a table to a file which contains Unicode characters? I have a sql file …

oracle unicode spool

How to remove unnecessary line breaks in SQL Plus Spooling?

I am spooling a package from a database and this is what I get: CREATE OR REPLACE PACKAGE BODY "CPI"."…

sql database command-line sqlplus spool

Spooling in Oracle adds spaces to columns... how can I avoid it?

I'm saving the results of a query in a csv file but unwanted spaces are added to some of the …

oracle spool

SQLPlus dynamic spool filename

i have an Oracle db and i want to export data to a file.However filename, extension and separator will …

oracle sqlplus spool

Hide SQL > statements in the spool file

I want to hide the "SQL> @test.sql" and "SQL> spool off" in the file test.txt(spool …

oracle sqlplus spool