LinuxQuestions.org
Visit Jeremy's Blog.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > Programming
User Name
Password
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.

Notices


Reply
  Search this Thread
Old 06-22-2015, 06:28 AM   #1
Aomine Daiki
LQ Newbie
 
Registered: Jun 2015
Location: Tunisia
Posts: 10

Rep: Reputation: Disabled
Redirect the output of a query in a file


How I can do to redirect the query result in a text file in
Code:
sqlplus
I tried:
Code:
start requete.sql > resultat.txt
but it dosen't work
 
Old 06-22-2015, 08:54 AM   #2
NevemTeve
Senior Member
 
Registered: Oct 2011
Location: Budapest
Distribution: Debian/GNU/Linux, AIX
Posts: 4,863
Blog Entries: 1

Rep: Reputation: 1869Reputation: 1869Reputation: 1869Reputation: 1869Reputation: 1869Reputation: 1869Reputation: 1869Reputation: 1869Reputation: 1869Reputation: 1869Reputation: 1869
Use spool command:
Code:
sql> spool resultat.txt
sql> @requete.sql
 
1 members found this post helpful.
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
redirect output to another file preetham.66666 Linux - Server 2 01-14-2015 07:33 AM
How to redirect output of query result txt file into tar srinu.kadem Programming 3 05-08-2014 04:24 AM
[SOLVED] cannot redirect output to file please help figure20012 Linux - Newbie 9 07-22-2012 07:09 PM
How to redirect output to a file? mus1402 Linux - Newbie 2 02-05-2006 09:42 AM
how to redirect the soundcard output to a file? jr0 Linux - General 2 10-31-2005 06:29 AM

LinuxQuestions.org > Forums > Non-*NIX Forums > Programming

All times are GMT -5. The time now is 05:52 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration