Tag: databases

USER_TABLESPACES

DBA_TABLESPACE_GROUPS

DBA_TABLESPACES

Statement failure

User process failure

Network failure

Instance failure

The tablespace must be offline

The tablespace must be online

The tablespace cannot have active segments

The administrator NOT needs the correct system privilege

sysdate

Truncate

avg

To_date

"SELECT"

"_Marketing"

m364DaYs

SELECT

SELECT last_name FROM employees WHERE last_name LIKE '%A_B%' ESCAPE '\';

SELECT last_name FROM employees WHERE last_name LIKE '%A_B%' ESCAPE;

SELECT last_name FROM employees WHERE last_name LIKE 'A_B%' ESCAPE '%';

SELECT last_name FROM employees WHERE last_name LIKE '%A_B%' ESCAPE '';

any outer join

a left outer join

a cross join

a right outer join

SUM(start_date)

AVG(start_date)

COUNT(start_date)

MIN(start_date)

SELECT TO_DATE (SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;

SELECT TO_CHAR (SYSDATE, 'FMDD, DY Month, YYYY') FROM dual;

SELECT TO_CHAR (SYSDATE, 'FMDay, DD Month, YYYY') FROM dual;

SELECT TO_CHAR (SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;

DELETE employees;

DESCRIBE employees;

ROLLBACK TO SAVEPOINT C;

ALTER TABLE employees SET UNUSED COLUMN sal;

GRANT SELECT ON employees TO SCOTT;