True

False

True

False

True

False

SELECT row_name INTO variable_name FROM table_name [WHERE condition];

SELECT column_name INTO variable_name FROM table_name [WHERE condition];

SELECT column_name INTO variable_name FROM table_name [WHEN condition];

SELECT table_name INTO variable_name FROM table_name [WHERE condition];

table_name record_type_name;

column_name record_type_name;

record_type_name record_name;

record_name record_type_name;

1

3

2

4

EXECUTE [or EXEC] database.function_name;

employee_name := employer_details_func;

SELECT employer_details_func FROM dual;

dbms_output.put_line(employer_details_func);

True

False

True

False

True

False

True

False

True

False

MIN

LOW

DOWN

LOWER

Records

Fields

Attributes

Cardinality

To return the absolute, positive value of a numeric expression.

To return the average value of a numeric expression.

To return the maximum value of a numeric expression.

To return the minimum value of a numeric expression.

DISTINCTIVE

UNIQUE

DISTINCT

DIFFERENT

Data Mode Lane

Data Manipulation language

Data Model Language

Different Mode Level

DELETE

UNION

SELECT

INSERT

UPDATE

SELECT

INSERT

INVERT

insert and delete only

update and delete only

update, delete and insert

insert and update only