←
SQLcl841 posts
SQLcl avatar

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.

◷ Joined April 2016▧ 265 Photos and videos
SQLcl avatar
SQLcl@oraclesqlcl·27 Nov 2023

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.

Post attachment
SQLcl avatar
SQLcl@oraclesqlcl·16 Nov 2023

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

Post attachment
SQLcl avatar
SQLcl@oraclesqlcl·1 Sep 2023

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

SQLcl avatar
SQLcl@oraclesqlcl·25 Aug 2023

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

Post attachment
SQLcl avatar
SQLcl@oraclesqlcl·2 Aug 2023

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!

SQLcl avatar
SQLcl@oraclesqlcl·19 Jul 2023

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

Post attachmentPost attachment
SQLcl avatar
SQLcl@oraclesqlcl·19 Jul 2023

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

SQLcl avatar
SQLcl@oraclesqlcl·7 Jun 2023

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