SID (Session Identifier)
A session identifier is a unique number assigned to each database user session when a
user connects to the database.
The traditional command line tool for executing SQL statements available with all Oracle
databases. Although recently superseded by GUI tools like Oracle’s free SQL Developer,
SQL*Plus remains hugely popular. It is also convenient to show examples using SQL*Plus.
Stored Procedures and Functions
A PL/SQL block that Oracle stores in the database and can be called by name from an
application. Functions are different than procedures in that functions return a value when
executed. When you create a stored procedure or function, Oracle parses the procedure or
function, and stores its parsed representation in the database.
A synonym is an alias for any database table, view, materialized view, sequence,
procedure, function, package, type, Java class schema object, user-defined object type, or
An Oracle database administrative user account name. SYS has access to all base tables
and views for the database data dictionary.
An Oracle database system privilege that, by default, is assigned only to the SYS user. It
enables SYS to perform high-level administrative tasks such as starting up and shutting
down the database.
Similar to SYSDBA, but with a limited set of privileges that allows basic administrative
tasks without having access to user data.
An Oracle database administrative user account name that is used to perform all
administrative functions other than starting up and shutting down the database.
The right to perform a particular action, or to perform an action on any database schema
objects of a particular type. For example, the privileges to create tables and to delete the
rows of any table in a database.