This post will show you how to use the SQLFORMAT command from SQL Developer to transform a query output to CSV. Out of the box CSV Enter the following into SQL Developer, I am using SQL Developer version 18.1 and execute it as a script by pressing F5. and here is the output: “EMPLOYEE_ID”,”LAST_NAME”,”SALARY” 198,”OConnell”,2600 199,”Grant”,2600 […]
This post shows you how to configure the Oracle Developer Tools extension for VS Code and then use it to query an existing table, create or alter database objects and execute PL/SQL. Prerequisites The versions I have used are shown in brackets Microsoft VS Code (1.35.1) Oracle Database ( XE 18.4.0.0.0) Installation Start VS Code and […]
Default Behaviour The out of the box behaviour of SQL Developer is that SQL worksheets share the same connection. What does that mean? If you perform a insert, update or delete in one worksheet without issuing a commit, the result(s) can be viewed in another shared worksheet. This can be illustrated by the following example. […]
This is a far more opinionated post than usual. It is not meant to inflammatory, my goal for this post is to have something tangible that I can point to the next time an Oracle Developer thinks they want or need to “do” incremental commits. In this post an incremental commit is defined as code […]
Looks like the first technical book for 2018 I will be reading has already be decided. Pete Finnigan has a new book coming out in early January. More details from the publishers, Apress can be found here. At the time of this post there was no preview available. Fortunately the listing on Amazon does so […]
iancarpenter.dev 
You must be logged in to post a comment.