How to import data from Oracle using SQL Assistant
Hi, I am trying to import some data from Oracle database. I used to extract data from Oracle and convert to .csv and then use the import function in SQL Assistant. However, this time the amount of data is so large that it is quite time consuming to do so. Is there any method that can export directly without going through .csv file step? Thx.
Re: How to import data from Oracle using SQL Assistant
Your input needs to be a file and it needs to be some form of delimited. In the SQLA options, you can specify the delimiting character. I think the default is | but I could be wrong. Once you've got your file defined, you need to create your DML statement. Put question marks (?) in as the variables for your file. I believe the order of the variables will be the order of the columns, so make sure the ordering matches up. Then, turn on the import functionality and execute the query. It should ask for a filename at the point. Navigate to it in your environment, and away you go.