how to store the output of query/stored procedure in text file?

Question

to store query output in text file (.txt)

Answer 1

Before executing in the Query Analyzer, select "Execution Mode" as "Results to file".



now as soon as you will press F5 or click to execute the sp or query, Query Analyzer will prompt to give you the file name and location to save the result.



hope it solves ur problem, if you mean some other thing, please reply back or call me on [phone]



happy coding,

-anuj

Answer 2

I have tried this in MS-SQL . I doesnt know about oracle.



this is the command,

osql.exe -S server_name -U user_name -P password -Q "procedure_name/query" -O "E:\file_name.extension"



eg:-

osql.exe -S pubs -U sa -P sa -Q "sp_getEmp"

-O "E:\myoutput.txt"



Hope this will help u.

Answer 3

just select what u want to be stored and then click copy(ctrl+c) and then open a new notepap and then press(ctrl+v) r paste. and save the file

Answer 4

cant tell u exactlly but if you are using cpp then rite clik on blank screnn and go for file.open/save etc... thats all there are examples in there

Answer 5

tail enter.txt > output.txt # overwrite tail enter.txt > output.txt # append tail enter.txt | tee output.txt # overwrite, and exhibit on exhibit tail enter.txt | tee -a output.txt # append, and exhibit on exhibit