ABIS Training & Consulting

SQL*Plus

Intended for

Everyone who has:

to write and execute SQL queries by means of SQL*Plus;
to generate reports.

Background

Participants should be familiar with a relational database (see course RDBMS concepts)

Training method

Classroom instruction. Demonstrations and exercises.

Course leader

Kris Van Thillo.

Duration

2 days.

Schedule

No public sessions are currently scheduled. We will be pleased to set up an on-site course or to schedule an extra public session (in case of a sufficient number of candidates). Interested ? Please contact ABIS.

Objectives

At the end of this course, the delegate will be able to use the Oracle database by means of the SQL*Plus interface. He/she will be able:

to use the SQL*Plus environment efficiently;
to configure the SQL*Plus environment;
to write simple queries;
to handle, adapt and execute SQL scripts;
to format the query results.

Main topics

Basic principles:
Relational database • table • line • column • index • domain
The SQL*Plus environment:
Commands to edit, to execute and to handle
Configuration of the environment • user variables • prompt interaction • bind variables • refcursors
Formatting of the result • columns • regrouping • titles
Data manipulation - the SELECT statement:
Basic syntax: select - from - where - group by -having - order by • operators and expressions • predicates • NULL • scalar functions in Oracle • column functions
Data manipulation • INSERT, UPDATE, DELETE statement