SQLcl @oraclesqlcl

From the makers of Oracle SQL Developer, your new Oracle Database command line interface. Click the Website link for instant download of latest version. download.oracle.com/otn_software/j… Zsh, mostly Joined April 2016

Tweets

842
Followers

5K
Following

143
Likes

189

SQLcl @oraclesqlcl

2 years ago

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.

1 4 25 4K 6

Download Image

SQLcl @oraclesqlcl

2 years ago

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

0 3 33 4K 7

Download Image

SQLcl @oraclesqlcl

2 years ago

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

0 7 27 3K 13

Download Image

SQLcl @oraclesqlcl

2 years ago

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

0 1 8 2K 2

Download Image

SQLcl @oraclesqlcl

2 years ago

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

0 3 9 2K 2

SQLcl @oraclesqlcl

2 years ago

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

0 6 8 2K 2

SQLcl @oraclesqlcl

2 years ago

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

0 2 24 2K 10

Download Image

SQL.ProductManager.Oracle.Databases @thatjeffsmith

2 years ago

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

0 11 29 5K 8

SQLcl @oraclesqlcl

2 years ago

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!

2 1 9 11K 3

SQLcl @oraclesqlcl

2 years ago

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

7 4 27 5K 1

Gerald Venzl 🚀 @GeraldVenzl

2 years ago

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-…

0 9 31 5K 7

Download Image

SQLcl @oraclesqlcl

2 years ago

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

0 8 22 3K 3

Download Image

SQLcl @oraclesqlcl

2 years ago

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

0 4 8 1K 3

Download Image

SQLcl @oraclesqlcl

2 years ago

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

1 4 23 2K 3

Download Gif

SQLcl @oraclesqlcl

2 years ago

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!

0 5 11 2K 4

Download Image

SQLcl @oraclesqlcl

2 years ago

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

0 2 5 788 3

Download Image

SQLcl @oraclesqlcl

2 years ago

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