CODEWITHSUNDEEP
sqloracle-databasesshsqlplus
Sterling Archer
Sterling Archer

Reputation: 22395

SQLPLUS saving to file

I have to use SQLPLUS for my database class, and our first assignment is simple saving.

I followed the instructions.. (I'm using PuTTY to access sqlplus)

"Use the following SQL commands in this exercise and try the SAVE and SPOOL commands to save your SQL commands and output to external files.

select table_name from all_tables where owner='UNIVERSITY';
select * from university.faculty;
select * from university.clubs;

For this lab, do the following:

(Obviously asking for help isn't against the rules, since the instructions are right there already.. i simply don't understand them or they're wrong)

When I type SAVE test.sql i yield => "Nothing to save"

When I type SAVE test.sql after a query, it saves only the last typed query.

How do I have it save ALL my queries instead of just the last one typed?

Upvotes: 6

Views: 52590

Answers (2)

Uma Maheswari
Uma Maheswari

Reputation: 1

Use spool option :

  1. go to file-> spool file->give a file name(* Be careful in giving the file name don't use any space in the file name as well as the folder name)
  2. now type command set lines 100 pages 100;
  3. type command cl scr;
  4. start typing your queries.
  5. either go to file -> spool-> spool off or
  6. type the command spool off;

Upvotes: 0

Sathyajith Bhat
Sathyajith Bhat

Reputation: 21851

How do I have it save ALL my queries instead of just the last one typed?

SAVE saves the content of the SQL*Plus buffer into the file. The buffer gets replaced with every SQL statement that you write, hence you get only the last command. Save has an append command that will append to the file.

So, first create your file.

save test.sql create

and append the file after every SQL script.

select * from employees
/
save test.sql append;
select * from departments
/
save test.sql append;

and so on

Upvotes: 7

Related Questions