ORACLE LIVE SQL IMPORT CSV DATA live oracle sql

Question

I'm now working on oracle live sql (provided online) Is there a method to import a csv file into this online platform, and if so, could you help offer a step-by-step guide? I've looked online for a solution but can't seem to find a connection to Oracle Live, the company's online platform.

Answer 1

Convert CSV to SQL

http://www.convertcsv.com/csv-to-sql.htm

This programme may be used to convert CSV to SQL statements. You have the option of using a local csv file or a URL. The datatype and restrictions can be changed in a variety of ways (NOT NULL etc ). DMLs may be created for delete, insert, update, and select.

SQLFIDDLE:

http://sqlfiddle.com/ The option "Text to DDL" is available on this page. Simply insert the text from a csv file, and the DDL to build and populate data in a table will be generated.

When you need to run DDLs and DMLs in Oracle 12c, use livesql. Other than that, there are a plethora of SQL query execution tools available online.