SQL Statements

The primary means of communicating with Oracle Database is by submitting SQL statements.

sap erp pp production planning training courses malaysia

• Submitting Commands and SQL to the Database
  There are several ways to submit SQL statements and commands to Oracle Database.
• About SQL*Plus
  SQL*Plus is the primary command-line interface to your Oracle database. You use SQL*Plus to start up and shut down the database, set database initialization parameters, create and manage users, create and alter database objects (such as tables and indexes), insert and update data, run SQL queries, and more.
• Connecting to the Database with SQL*Plus
  When you connect with SQL*Plus, you are connecting to the Oracle instance.

sap erp procurement material management training courses malaysia

1.3.1 Submitting Commands and SQL to the Database

There are several ways to submit SQL statements and commands to Oracle Database.

red hat openstack training courses malaysia

• Directly, using the command-line interface of SQL*Plus
• Indirectly, using a graphical user interface, such as Oracle Enterprise Manager Database Express (EM Express) or Oracle Enterprise Manager Cloud Control (Cloud Control)With these tools, you use an intuitive graphical interface to administer the database, and the tool submits SQL statements and commands behind the scenes. See Oracle Database 2 Day DBA and the online help for the tool for more information.
• Directly, using SQL DeveloperDevelopers use SQL Developer to create and test database schemas and applications, although you can also use it for database administration tasks.See Oracle SQL Developer User’s Guide for more information.

Oracle Database also supports a superset of SQL, which includes commands for starting up and shutting down the database, modifying database configuration, and so on.

red hat Linux certification malaysia