@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.

 Zsh, mostly
download.oracle.com/otn_software/java/sqldeveloper/sqlcl-latest.zip
Joined April 2016
  • Tweets841
  • Following144
  • Followers5K
265Media
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
3,715
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
SQL> cd c:\users\jdsmith SQL> spool regions.sql SQL> ddl regions CREATE TABLE "HR"."REGIONS" ( "REGION_ID" NUMBER CONSTRAINT "REGION_ID_NN" NOT NULL ENABLE, "REGION_NAME" VARCHAR2(25) COLLATE "USING_NLS_COMP" ) TABLESPACE "USERS" ; CREATE UNIQUE INDEX "HR"."REG_ID_PK" ON "HR"."REGIONS" ("REGION_ID") TABLESPACE "USERS" ; ALTER TABLE "HR"."REGIONS" ADD CONSTRAINT "REG_ID_PK" PRIMARY KEY ("REGION_ID") USING INDEX "HR"."REG_ID_PK" ENABLE; SQL> select /*insert*/ * from regions; REM INSERTING into REGIONS SET DEFINE OFF; Insert into REGIONS (REGION_ID,REGION_NAME) values (1,'Europe'); Insert into REGIONS (REGION_ID,REGION_NAME) values (2,'Americas'); Insert into REGIONS (REGION_ID,REGION_NAME) values (3,'Asia'); Insert into REGIONS (REGION_ID,REGION_NAME) values (4,'Middle East and Africa'); SQL> spool off SQL>

ALT SQL> cd c:\users\jdsmith SQL> spool regions.sql SQL> ddl regions CREATE TABLE "HR"."REGIONS" ( "REGION_ID" NUMBER CONSTRAINT "REGION_ID_NN" NOT NULL ENABLE, "REGION_NAME" VARCHAR2(25) COLLATE "USING_NLS_COMP" ) TABLESPACE "USERS" ; CREATE UNIQUE INDEX "HR"."REG_ID_PK" ON "HR"."REGIONS" ("REGION_ID") TABLESPACE "USERS" ; ALTER TABLE "HR"."REGIONS" ADD CONSTRAINT "REG_ID_PK" PRIMARY KEY ("REGION_ID") USING INDEX "HR"."REG_ID_PK" ENABLE; SQL> select /*insert*/ * from regions; REM INSERTING into REGIONS SET DEFINE OFF; Insert into REGIONS (REGION_ID,REGION_NAME) values (1,'Europe'); Insert into REGIONS (REGION_ID,REGION_NAME) values (2,'Americas'); Insert into REGIONS (REGION_ID,REGION_NAME) values (3,'Asia'); Insert into REGIONS (REGION_ID,REGION_NAME) values (4,'Middle East and Africa'); SQL> spool off SQL>

3
33
3,975
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
SQLcl is a database change management tool that allows you to capture, version, and deploy database changes simply and in an automated fashion. This cuts back on manual work such as recreating tables, making sure database object change scripts are properly working, and rolling back unwanted alterations.

ALT SQLcl is a database change management tool that allows you to capture, version, and deploy database changes simply and in an automated fashion. This cuts back on manual work such as recreating tables, making sure database object change scripts are properly working, and rolling back unwanted alterations.

7
1
27
3,449
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
Oracle SQLcl is a powerful command line interface for the Oracle Database.

ALT Oracle SQLcl is a powerful command line interface for the Oracle Database.

1
1
8
2,323
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

Oracle Database Tools at Cloud World 2023

Here's the roundup and summary for all of our talks, theater presentations, hands-on labs, and digital content at Oracle Cloud World 2023, September 19-21!

thatjeffsmith.com
3
8
1,846
Video replay from our webinar is now available! social.ora.cl/6017Pqx6P
6
8
1,832
Did you know: You can use the LOAD command to generate table DDL for a given CSV file!
Syntax: load <table_name> file.csv SHOW_DDL This will let Oracle SQLcl read the contets of your CSV file and suggest an Oracle Database CREATE TABLE command to store the data.

ALT Syntax: load <table_name> file.csv SHOW_DDL This will let Oracle SQLcl read the contets of your CSV file and suggest an Oracle Database CREATE TABLE command to store the data.

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

How to maximize your command line experience with Oracle

How to setup Oracle SQLcl to give you YOUR perfect Oracle Database command-line experience! Formatting, syntax highlighting, and much more!

thatjeffsmith.com
11
27
4,559
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
1
9
11,109
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
6
4
2
26
4,593
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
1
1
7
1,013
A quick example: 1. Create a connection and save it 2. List available connections, then use one!
Using SQLcl to connect as SYS, then saving that connection with a name, and opting in to include the password.

ALT Using SQLcl to connect as SYS, then saving that connection with a name, and opting in to include the password.

Using SQLcl to list the names of saved connections, then using one to connec. Finally showing the connection details.

ALT Using SQLcl to list the names of saved connections, then using one to connec. Finally showing the connection details.

1
1
3
771
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-too…
9
1
31
4,509
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
Oracle SQLcl can easily install the SH sample schema now, no SQLLDR or Oracle Client required!

ALT Oracle SQLcl can easily install the SH sample schema now, no SQLLDR or Oracle Client required!

8
22
2,741
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
set feedback, echo off spool regions.sql ddl hr.regions select /*insert*/ * from hr.regions spool off

ALT set feedback, echo off spool regions.sql ddl hr.regions select /*insert*/ * from hr.regions spool off

the results SQL file generated from using Oracle SQLcl to spool out the DDL for a table and then the records in the table using the INSERT hint

ALT the results SQL file generated from using Oracle SQLcl to spool out the DDL for a table and then the records in the table using the INSERT hint

4
8
1,093
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
1,822
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-just-is… Read, subscribe, and follow!
5
1
11
2,036
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
The DDL command in Oracle SQLcl makes it easy to use the database package DBMS_METADATA to retrieve the code required to build your tables, views, and more. You can use 'set ddl' to configure how your DDL is generated.

ALT The DDL command in Oracle SQLcl makes it easy to use the database package DBMS_METADATA to retrieve the code required to build your tables, views, and more. You can use 'set ddl' to configure how your DDL is generated.

2
5
794
Animated GIF demo time! syntax highlighting, statusbar, tab completion, sql history, inline editing, parser feedback (invalid SQL), sqlformat #oracle #database #sql #cli
1
1
562
Replying to @DBAMarco @oraclesqlcl
Yes ! Ctrl+R show keymap - lists all keyboard shortcuts
2
7
788
Load more