Marco Pachaly-Mischke SQLcl Yes ! Ctrl+R show keymap - lists all keyboard shortcuts

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

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

Today's tip comes from one of our favorite Oracle ACE Program members, Erik van Roon ! 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!

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

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

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

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

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

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

Missed our LiveLab webinar with Zachary Talke ? 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!

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

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

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

Make sure to join us next week at CloudWorld 2023 as SQLcl product manager Zachary Talke 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

We have a new 30minutes hands-on LiveLab tutorial for getting started in your CI/CD journey with Oracle APEX and your app schemas data, programs, and ORDS - GET PUT POST DELETE your Oracle Database REST APIs! social.ora.cl/6017ugKD7

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

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.