How to load csv to a table in an Oracle Database from the command line, OR how to generate DDL for a new table from a CSV.

How to load csv to a table in an Oracle Database from the command line, OR how to generate DDL for a new table from a CSV.
Oracle SQL Developer Web version 21.3 introduces support for Oracle Data Pump – see your jobs, download DMP files, and view Logs.
Join us Oct 26-27 for Oracle Database World!
Our team will have two talks + two labs to learn more about our database tools and CI/CD for the Oracle Database!
Installing Oracle REST Data Services is as easy as ‘yum install ords’!
Get REST APIs and SQL Developer Web for your Oracle Database in just a few moments!
Our presentation recording and slides from our Spotlight Series – Database Change Management talk.
Change management for an Oracle Database and associated application schemas. Why AND how!
Is there a way using Collection Query to return a list of numbers as a JSON array using Oracle REST Data Services for my REST API?
The answer is, YES!
I’ve talked about trapping PL/SQL Exceptions in your REST APIs before – you can catch up on that here. But, you can stay RIGHT HERE – this post covers the same material, just in more detail. Got a question from someone new to ORDS, let’s pretend their name is ‘Kartik.’ They wanted help figuring out why their ORDS Exception block wasn’t properly setting the Response Header STATUS code, in this case a 400. Let’s look…
How to debug and diagnose those pesky errors in your REST APIs with ORDS – print errors to screen, correlate HTTP errors to the SQL in your DB and more.
Quick update – we put out updates with bug fixes for both SQLcl and SQL Developer version 21.2 yesterday. Time to go download (again!)
You can save and recall work in your online SQL worksheets with Database Actions. Plus a quick sneak-peek of some charting enhancements!