Sqlplus log results to file

It said It'll be great help for me. I have a perl file that calls the sql file Select a portion of file based on query. Hi friends : I am having a small problem and ur help is needed I have a long file from which i want to select only some portions after filtering grep.

My file looks like : header xxyy lmno xxyy wxyz footer header abcd xy pqrs footer. RedHat Commands. OpenSolaris Commands. Linux Commands. SunOS Commands. FreeBSD Commands. Full Man Repository. Advanced Search. Contact Us. Forum Rules. Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community.

It only takes a minute to sign up. Connect and share knowledge within a single location that is structured and easy to search. This is not a duplicate of " Spool query to file without output on screen ". Now I have spooled off the value and saved it to a file. I will be running it as a separate file for the expiring users. To turn that off, use set heading off. Sign up to join this community. The best answers are voted up and rise to the top. Quick Links. Search Forums.

Show Threads. Show Posts. Shell Programming and Scripting. Top Forums Shell Programming and Scripting sqlplus error output to different error log file.

Registered User. Join Date: Feb Join Date: Jan Tomas, Seems like you are asking for too much to write in a single command! I do not think it is possible to execute However, we can certainly write a shell script that satisfies your requirement, albeit with some modifications. Code :. Prof Mo. Join Date: Mar I only think that will work if the input sql file exists.

If you want to save the results in a txt file, you can do this in SSMS. Create a query and execute the query. An option to specify the name and path will be displayed. We will call the results in a file named Results.

You can save the results in a file from here. This option is useful when you are using batch files to automate tasks. The command used the myquery. PowerShell is an extremely popular command line shell to automate tasks.

We can export the SQL Server query results to a txt file by executing the following cmdlets:. Invoke-Sqlcmd will call the script myquery. The results will be the following:. In SSMS, when you right click a database. There is an option to import or export data. In Destination, select Flat File Destination and press browse to specify the file name and path:. Specify the query of the file myquery. A message specifying that the statement is valid should be displayed:.

You could also perform a similar task using Visual Basic.