This is an old revision of the document!
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.
SELECT TABLE_NAME FROM user_tables;
DESC <table_name>; DESCRIBE emp;
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;
SET LINES 100 SET PAGES 100