Develop with Oracle SQL*Plus
You can use SQL*Plus to connect to your Oracle Database Exadata Express Cloud Service and develop on the database.
Topics:
Enter and Execute Commands
After you connect to your Oracle Database Exadata Express Cloud Service using SQL*Plus, you can execute commands from the command-line to develop the database.
To execute a command from SQL*Plus, type the command in the command-line, and press the Return key. The SQL*Plus allows you to enter three types of commands as:
-
SQL commands
-
PL/SQL blocks
-
SQL*Plus commands
To learn more about the types of commands that can be executed, see Entering and Executing Commands in SQL*Plus® User's Guide and Reference.
Manage Database Objects with SQL*Plus
Oracle SQL*Plus allows you to manage various database objects in your Oracle Database Exadata Express Cloud Service by entering commands in the command-line.
Query and Manipulate Data Using SQL*Plus
Oracle SQL*Plus allows you to query and manipulate data in your Oracle Database Exadata Express Cloud Service by entering commands in the command-line.
Use SQL*Plus to Data Load
Using Oracle SQL*Plus, you can load data from an on-premise database to your Oracle Database Exadata Express Cloud Service or vice-versa. Similarly, you can also use the SQL*Plus features to load data between your Exadata Express service and any other cloud service which supports connecting through SQL*Plus.
SQL*Plus supports loading bulk data or copying database objects from one database to another by various means. As your Exadata Express service allows you to connect from SQL*Plus, it also supports features to load data between your database on the service and any other database either on cloud or on-premise. The following options are available for you to load data to/from your Exadata Express service:
Running SQL scripts to create database objects & load data.
Follow these steps, to execute SQL scripts with Exadata Express service:
-
Using SQL*Plus, connect to your Exadata Express service. See Connect SQL*Plus.
-
To execute a script of SQL commands to load data into your Exadata Express service, execute the following commands at the command prompt:
START <filename> or @<filename>
SQL*Plus runs the commands in the file, and displays the status of the execution.
Note:
SQL*Plus assumes the file has a
.sql
extension by default.
For further information on using SQL*Plus for executing SQL scripts, see Running Scripts in SQL*Plus® User's Guide and Reference .
Using SQL *Loader Utility
A typical SQL*Loader session takes as input a control file, which controls the behavior of SQL*Loader, and one or more datafiles. The output of SQL*Loader is an Oracle database (where the data is loaded), a log file, a bad file, and potentially, a discard file. It has a powerful data parsing engine that puts little limitation on the format of the data in the datafile. SQL Loader conventional path and direct path work remotely as long as there is a service for the target database that the user can provide in the connect string. It can be run from a remote machine where the data files are present, and therefore, there is no need to send files to the target machine using SFTP.
For further information, see SQL*Loader Command-Line Reference in Oracle Database Utilities.