Reason 5812 why you are better off using @oraclesqlcl over #SQLPlus

@oraclesqlcl FYI

OMG, the new @oraclesqlcl (24.1.0) provides syntax highlighting _as you type_ 😱. Also, things in red are errors 😁

Did you know: You can use the LOAD command to generate table DDL for a given CSV file!

Need to create a DDL and Data script for a table? It's as simple as using SPOOL, DDL, and /*INSERT*/ commands! . You can also 'shape' the DDL using the various SET DDL commands such as . SET DDL SCHEMA OFF. SET DDL TABLESPACE OFF

Just deployed a massive 14,000 changesets update to a customer's PROD database with Oracle's SQLcl & Liquibase. It was a huge Forms to APEX migration. Seamless & powerful! .Here's a glimpse of our achievement #oraclesqlcl #orclAPEX #liquibase

And while I'm at it, @oraclesqlcl now has tab completion for Liquibase commands 💪

Change the format of query results in @OracleSQLDev & @oraclesqlcl with. SET SQLFORMAT <fmt>. Or by adding a format comment after SELECT. SELECT /*<fmt>*/. Supported formats include. csv, html, xml, json, fixed, insert, loader, delimited, ansiconsole

Part 2 of my mini series explaining CI/CD in the context of relational databases is live :) In this now-complete mini series you learn how to use the awesome @oraclesqlcl projects command to update your application from version 1.0 to 1.1. #thementage25.

Need a single SQL file to both create and populate a table? A combination of SPOOL, DDL, and SELECT /*insert*/ should do the job! . #oracle #database #sql

Learning how to incorporate CI/CD into my #orclapex development process using @gitlab, @oraclesqlcl, and @liquibase from @RoelH at #HrOUG2023. #HrOUG23 @Hroug_Croatia

@thatjeffsmith @oraclesqlcl

Using sqlCL 23.1 with the parameter -skipExportDate it seems that the date is inside the file . apex export -applicationid 108 -skipExportDate . it's a bug. Can someone verify it?. @oraclesqlcl @krisrice #sqcl #orclapex #bug #sqlcl231

Updated my docker for @oraclesqlcl to use @graalvm +JS making JavaScript usage work out of the box. published >.

New and improved @oraclesqlcl scripts with better error handling can now be found at:

@r_grzegorczyk explaining how he used Liquibase in @oraclesqlcl to automate the deployment of 1.1 million lives of code changes to 14,000 database objects. #ougn2024

We have a new 30minutes hands-on LiveLab tutorial for getting started in your CI/CD journey with @OracleAPEX and your app schemas data, programs, and @OracleREST REST APIs!.

He’s going to be at #emeaUtrecht all day … questions about @oraclesqlcl @OracleSQLDev or whatever. ask @thatjeffsmith @nl_OUG

Does anyone know if I can make @oraclesqlcl giving me some information about a MLE module?