Active 2 years, 1 month ago. Viewed 76k times. I am not a professional, sorry. But perhaps you can help me anyway I need them in one field with linebreaks like stored in the database. I would be very glad, if some could help me! Improve this question. Community Bot 1. Christoph Holzapfel Christoph Holzapfel 31 1 1 gold badge 1 1 silver badge 2 2 bronze badges.
I'm afraid sqlplus is not the right tool for CVS export. It's mighty tool, but lacks formating options. Add a comment. Active Oldest Votes. Example: select '"' 'col1' '","' '"col2"' '","' '"col3"' from dual union select '"' col1 '","' col2 '","' col3 '"' from table; 2 This one is tricky. Improve this answer. Andriy M You can change these settings at the runtime or by setting them as default in the User Profile in the login.
The syntax is:. But not everyone would be interested in going through the messy and convoluted process of working with custom scripts. You might be interested in getting your CSV files out of Oracle painlessly into a destination and moving on with your business. There is a very robust and intuitive solution to accomplish the same.
Hevo Data is a modern ETL tool with extensive capabilities to extract data from a source Oracle DB in this case to a destination platform or a data warehouse.
Hevo Data, a No-code Data Pipeline, is a fully managed data integration solution that helps users migrate data from multiple sources like databases and cloud applications to their data warehouses.
To do so, follow the below-mentioned steps. You can manually alter these settings before file generation. However, depending on your needs, you can also change the defaults of various settings in your User Profile , located in the login. After inserting your query, you also need to halt spool in order to close the output file. This can be done by using the spool off command. You can now finally insert your query. Instead of manually entering every line, you can also enter all the settings into a new script file.
Hevo can help you Integrate your data from numerous sources like Oracle and load them into a destination to Analyze real-time data with a BI tool such as Tableau. It will make your life easier and data migration hassle-free. It is user-friendly, reliable, and secure. We would love to hear from you! Question and Answer. You Asked It is probably apparent from my job title that my role is far from a dba. Spooling Data to.
January 22, - am UTC. More to Explore. Dev Gym Classes, workouts and quizzes on Oracle Database technologies. Expertise through exercise!
0コメント