SQLcl

Need to quickly load some data to a new or existing table? Take a look at the LOAD command! Use the 'set load format' command to configure how your data is interpreted/mapped to your table.

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

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! social.ora.cl/6017ugKD7

Make sure to join us next week at CloudWorld 2023 as SQLcl product manager @talke_tech takes you through the ins and outs of SQLcl & teaches you Liquibase for managing your Oracle DB App installs and upgrades Talk: social.ora.cl/6012P45MQ Lab: social.ora.cl/6013P45Mv

So much SQLcl content at Cloud World 2023, don't miss it! LiveLabs, talks, and theater presentations - come meet our dev and product teams, and say hello! Our PM Jeff Smith has put together a list of all of our Database Tools talks for your convenience social.ora.cl/6012PQVpp

Video replay from our webinar is now available! social.ora.cl/6017Pqx6P

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

New post! These are things I tweak/configure when putting down a fresh copy of @oraclesqlcl thatjeffsmith.com/archive/2023/0… #oracle #database #developers #sql

Missed our LiveLab webinar with @talke_tech ? No worries, we recorded it! social.ora.cl/6011Pw2FU See the video description for links to the LiveLab and an open Slack Channel where you can interact with others learning how to version your schemas & our dev team!

Don't miss our event, tomorrow! social.ora.cl/6011PpdWv Learn all about how to get a handle on versioning your database schemas and code using SQLcl with our built-in and enhanced Liquibase support! #oracle #cicd #database #developers

A quick example: 1. Create a connection and save it 2. List available connections, then use one!

With #oracle SQLcl version 23.2 we are offering an exciting new feature! You can now save and re-use connections, from the command line! Optionally save passwords, those passwords if saved, will be secured safely in local wallets. Blog/Demo: social.ora.cl/6012PRqWo

Never having to worry about whether you are on the latest version of @oraclesqlcl anymore - loving it! You can get the script here: github.com/gvenzl/oracle-…

Installing the Sales History (SH) sample schema is now even easier! Our pm @thatjeffsmith shows how here Blog: social.ora.cl/6016OAinr Kudos to @GeraldVenzl and team on our sample data modernization project! #oracle #sql #database #data #developers

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

Did you know we had a SQL and PL/SQL Formatter built into the command-line for Oracle Database? Simply use the 'FORMAT' command to either format the code in your buffer or in a file. Here's a quick demonstration! #oracle #sql #database #pretty #code #developers

Today's tip comes from one of our favorite @oracleace members, @evrocs_nl ! It's actually a series of posts showing how to build your own commands in SQLcl evrocs.nl/when-great-jus… Read, subscribe, and follow!

Need the DDL for a table, or maybe just the SQL under a VIEW? Use the DDL command! Want to 'shape' the generated code? Use SET DDL #oracle #developer #sql

Animated GIF demo time! syntax highlighting, statusbar, tab completion, sql history, inline editing, parser feedback (invalid SQL), sqlformat #oracle #database #sql #cli

@DBAMarco @oraclesqlcl Yes ! Ctrl+R show keymap - lists all keyboard shortcuts