Tag: databases

ALTER TABLE TABLE1 SHRINK;

ALTER TABLE TABLE1 SHRINK SPACE;

ALTER TABLE TABLE1 SHRINK UNUSED;

ALTER TABLE TABLE1 SHRINK ROWs;

WHERE clauses

START WITH and CONNECT BY clauses

select lists

HAVING clauses

exec DBMS_STATS.UNLOCK_SCHEMA_STATS('TABLE_NAME','OWNER');

exec DBMS_STATS.UNLOCK_SCHEMA_STATS('OWNER','TABLE_NAME');

exec DBMS_STATS.UNLOCK_DB_STATS('DB_NAME','OWNER','TABLE_NAME');

exec DBMS_STATS.UNLOCK_TABLE_STATS('TABLE_NAME','OWNER');

exec DBMS_STATS.UNLOCK_TABLE_STATS('OWNER','TABLE_NAME');

True

False

colons

parentheses

commas

semi-colons

True

False

True

False

Indexes

Hints

Tables

Bitmaps

left join

right join

outer join

equil join

simple join

left outer join

inner join

equil join

right outer join