Pl sql output query to file

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Ask Question. Asked 12 years, 3 months ago. Active 4 years, 4 months ago. Viewed k times. Improve this question. MatthewMartin Add a comment. Active Oldest Votes. Improve this answer.

Collectives on Stack Overflow. Learn more. Asked 12 years, 8 months ago. Active 3 years, 8 months ago. Viewed 55k times. So I'd also like the data split across multiple files; out1. Anyone have any idea how to do this? Improve this question. Jagger 9, 7 7 gold badges 46 46 silver badges 84 84 bronze badges.

Rich Rich 3, 5 5 gold badges 29 29 silver badges 45 45 bronze badges. Thanks for your response - it was extremely useful. Would it be possible to name the file based on Sysdate? October 07, - am UTC. Is there any other way I can write my SQL query output into. Or Extracting the oracle concurrent job output into.

Thanks, Karthik. October 26, - am UTC. Load up the Karthik, October 26, - pm UTC. Thanks for your reply. Please guide me is there any other way I can extract the output in. October 26, - pm UTC. There is nothing to stop you from download the 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. This option is very useful if you are writing code and you need to integrate this task to the code.

In region Namespaces add System. IO and Data. IO is used to write information to a file in this scenario a txt file and Data. The second line is to specify the connection information SQL Server name, database name and Authentication method :. The try structure is used to handle exceptions. The line with "while reader. Read " is used to read row by row the results of the SQL Query. This is used to handle errors.