oraclesqlcl's profile picture. 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

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

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.

oraclesqlcl's tweet image. 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.

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

oraclesqlcl's tweet image. 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

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

oraclesqlcl's tweet image. 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

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

oraclesqlcl's tweet image. 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

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


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

oraclesqlcl's tweet image. Did you know: You can use the LOAD command to generate table DDL for a given CSV file!

SQLcl さんがリポスト

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


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!

oraclesqlcl's tweet card. Take control of your database with automated schema changes

youtube.com

YouTube

Take control of your database with automated schema changes


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


SQLcl さんがリポスト

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

GeraldVenzl's tweet image. 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-…

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

oraclesqlcl's tweet image. 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

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

oraclesqlcl's tweet image. 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
oraclesqlcl's tweet image. 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

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


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!

oraclesqlcl's tweet image. 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!

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

oraclesqlcl's tweet image. 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

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


SQLcl さんがリポスト

Yes ! Ctrl+R show keymap - lists all keyboard shortcuts


Loading...

Something went wrong.


Something went wrong.