Develop with Oracle SQLcl
Oracle SQLcl is a powerful java-based command line interface (CLI) for Oracle Database. You can use SQLcl to connect to your Oracle Database Exadata Express Cloud Service and develop on the database.
Topics:
Manage Database Objects with SQLcl
Oracle SQLcl allows you to create and manage various database objects in your Oracle Database Exadata Express Cloud Service.
Query and Manipulate Data Using SQLcl
Oracle SQLcl allows you to query and manipulate data in your Oracle Database Exadata Express Cloud Service by entering commands in the command-line.
Use the help
command in SQLcl
Oracle SQLcl provides help
command to get assistance in using any command supported by SQLcl.
Typing help
from the SQLcl command line, after connecting to your Oracle Database Exadata Express
Cloud Service, lists all the commands supported by SQLcl.
SQL> help
For help on a topic type help<topic>
List of Help topics available:
/
@
@@
ACCEPT
ALIAS
APEX
APPEND
ARCHIVE LOG
BREAK
BRIDGE
BTITLE
CD
CHANGE
CLEAR
COLUMN
COMPUTE
CONNECT
COPY
CTAS
DDL
DEFINE
DEL
DESCRIBE
DISCONNECT
EDIT
EXECUTE
EXIT
FORMAT
GET
HISTORY
HOST
INFORMATION
INPUT
LIST
LOAD
NET
NOHISTORY
OERR
PASSWORD
PAUSE
PRINT
PROMPT
QUIT
REMARK
REPEAT
RESERVED WORDS
REST
RUN
SAVE
SCRIPT
SET
SHOW
SHUTDOWN
SODA
SPOOL
SSHTUNNEL
START
STARTUP
STORE
TIMING
TNSPING
TTITLE
UNDEFINE
VARIABLE
WHENEVER
XQUERY
Note:
The new commands supported by Oracle SQLcl over SQL*plus are highlighted.By executing help <command>
will print the help documentation for that command.
SQL> help information
INFORMATION
--------
This command is like describe but with more details about the objects requested.
INFO[RMATION] {[schema.]object[@connect_identifier]}
INFO+ will show column statistics
Use SQLcl to Data Load
Oracle SQLcl, allows you to load data to your Oracle Database Exadata Express Cloud Service using multiple insert statements or from a csv file.
Pre-requisites
In order to load data into your Exadata Express service from an external data file, ensure that:
-
The first row of the file is a header row, and the columns in the header row match the columns defined on the table.
-
The columns are delimited by a comma and optionally enclosed in double quotes.
-
The lines are terminated with standard line terminators for windows, unix or mac.
-
The file is encoded UTF8.
Procedure
Follow these steps, to perform data loading using SQLcl:
Note:
-
The load is processed with 50 rows per batch.
-
If
AUTOCOMMIT
is set in SQLCL, a commit is done every 10 batches. -
The load is terminated if more than 50 errors are found.