Tag: databases

LONG VARCHAR

BYTEINT

DATE

TIMESTAMP WITH ZONE

Can be the object of an IN or NOT IN clause

Can be the object of EXISTS or NOT EXISTS

Support quantifiers ALL, ANY, SOME

Support LIKE or NOT LIKE used with a

Cannot specify more than one column to match

CREATE

DROP

MODIFY

ALTER

GRANT

REPLACE

SELECT DISTINCT position, manager

SELECT position, manager DISTINCT

SELECT position, manager

SELECT position, DISTINCT manager

SQL*Plus commands cannot be abbreviated.

SQL*Plus commands are accesses from a browser.

SQL*Plus commands are used to manipulate data in tables.

SQL*Plus commands manipulate table definitions in the database.

Insert

update

select

describe

delete

rename

Selection, projection, join

Difference, projection, join

Selection, intersection, join

Intersection, projection, join

Difference, projection, product

The sort is in ascending by order by default

The sort is in descending order by default

The ORDER BY clause must precede the WHERE clause.

The ORDER BY clause is executed on the client side.

The ORDER BY clause comes last in the SELECT statement.

The ORDER BY clause is executed first in the query execution.

updating

viewing

deleting

inserting

truncating

It executes the DELACCOUNT PL/SQL routine.

It runs the DELACCOUNT.SQL script file.

It creates the DELACCOUNT file using the default file extension.

It invokes the editor to edit the contents of the DELACCOUNT file.