SQLcl

From the makers of Oracle SQL Developer, your new Oracle Database command line interface. Click the Website link for instant download of latest version.

[SQLcl @oraclesqlcl]

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.

[SQLcl @oraclesqlcl]

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

[SQLcl @oraclesqlcl]

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!

https://t.co/9YaVV8gDK0

[SQLcl @oraclesqlcl]

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: https://t.co/oO1KxgYVgC

Lab: https://t.co/B8JtadazBF

[SQLcl @oraclesqlcl]

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
https://t.co/ub9AktNBhN

[SQLcl @oraclesqlcl]

Video replay from our webinar is now available!

https://t.co/sPd11r11bN

[SQLcl @oraclesqlcl]

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

[that Jeff Smith @thatjeffsmith]

New post! These are things I tweak/configure when putting down a fresh copy of @oraclesqlcl

https://t.co/OFsfw5ZM0s

#oracle #database #developers #sql

[SQLcl @oraclesqlcl]

Missed our LiveLab webinar with @talke_tech ? No worries, we recorded it!
https://t.co/Z4boOQDfbT

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!

[SQLcl @oraclesqlcl]

Don't miss our event, tomorrow!
https://t.co/Ca92whMUCO

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

[SQLcl @oraclesqlcl]

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

[SQLcl @oraclesqlcl]

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: https://t.co/s40XDnQgp3

[Gerald Venzl 🚀 @GeraldVenzl]

Never having to worry about whether you are on the latest version of @oraclesqlcl anymore - loving it!

You can get the script here: https://t.co/Y6ERp0xNsf

[SQLcl @oraclesqlcl]

Installing the Sales History (SH) sample schema is now even easier! Our pm @thatjeffsmith shows how here

Blog: https://t.co/bBqYaT4Kp0

Kudos to @GeraldVenzl and team on our sample data modernization project!

#oracle #sql #database #data #developers

[SQLcl @oraclesqlcl]

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

[SQLcl @oraclesqlcl]

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

[SQLcl @oraclesqlcl]

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

https://t.co/LGg3GHmjnQ

Read, subscribe, and follow!

[SQLcl @oraclesqlcl]

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

[SQLcl @oraclesqlcl]

Animated GIF demo time!

syntax highlighting, statusbar, tab completion, sql history, inline editing, parser feedback (invalid SQL), sqlformat

#oracle #database #sql #cli

[that Jeff Smith @thatjeffsmith]

@DBAMarco @oraclesqlcl Yes !
Ctrl+R

show keymap - lists all keyboard shortcuts