Claus_Jambrich_5663

Start Command - SQL*Plus vs SQL-Jobs

Discussion created by Claus_Jambrich_5663 on Feb 3, 2017
Latest reply on Apr 5, 2017 by Phearith_Mao_417
We were asked, why an SQL-Job cannot execute a command like:

start some_file.sql

Please be aware, that start is not an SQL-command but a SQL*Plus command (for a list see here). Our SQL-jobs cannot execute commands from tools like SQL*Plus, SQL Developer or from Microsoft Server Management Studio. These SQL-clients have inbuilt commands that you can use in their command line windows, but are not SQL-commands. They differ from tool to tool and work only inside these tools on a dedicated database.
SQL, 'Structured Query Language', is a standard language for accessing databases and it is vendor-independent. It is a programming language designed to manage data stored in relational databases. SQL operates through simple, declarative statements. This keeps data accurate and secure, and helps maintain the integrity of databases, regardless of size. Examples are:
SELECT, DELETE, INSERT, ALTER TABLE etc.

Outcomes