Tag: databases

Substitution variables

Replacement variables

Prompt variables

Instead-of variables

The SQL*Plus Keyword.

The username

The password

The database name

17000.00

17000*****

****170.00

**17000.00

an error statement

Convert any date literal to a date

Convert any numeric literal to a date

Convert any character literal to a date

Convert any date to a character literal

Format ’10-JAN-99’ to ‘January 10 1999’

select

delete

execute

alter table

create table

String

Character

Integer

Calander

Numeric

Translation

The UNIQUE constraint does not permit a null value for the column.

A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.

The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.

The NOT NULL constraint ensures that null values are not permitted for the column.

GRANT select ON dept TO ALL_USERS;

GRANT select ON dept TO ALL;

GRANT QUERY ON dept TO ALL_USERS;

GRANT select ON dept TO PUBLIC;

Unique

Not null

Check

Primary key

Foreign key

a schema object

a subquery that can contain an ORDER BY clause

another name for a view that contains group functions

a subquery that is part of the FROM clause of another query