Pentru a crea tabelele si tabele similare cu denumiri in limba romana, se poate folosi acest fisier.

Documentatia SQL pentru Oracle Database 11g se gaseste la acest link, de unde poate fi descarcata in format pdf.

Oracle Live SQL

Download masina virtuala Vagrant

Download masina virtuala (.ova)

Direct Software download

• Lista cu tabelele la care are acces userul curent:

 SELECT TABLE_NAME FROM user_tables; 

• Coloanele unui tabel:

 DESC <table_name>; DESCRIBE emp; 

• Verificarea constrangerilor existente:

SELECT * FROM user_constraints; 
SELECT constraint_name, constraint_type, TABLE_NAME FROM user_constraints WHERE REGEXP_LIKE(TABLE_NAME, 'EMP|DEPT|SALGRADE'); 
SELECT constraint_name, constraint_type, TABLE_NAME FROM user_constraints WHERE TABLE_NAME = 'EMP'; 
 
SELECT * FROM user_cons_columns;

• Formatare afisare

SET LINES 100
SET pages 100