This shows you the differences between two versions of the page.
bd:resurse:tables [2019/03/05 19:24] ciprian.truica [Tabele] |
bd:resurse:tables [2021/03/01 15:49] (current) ciprian.truica [Documentatia SQL] |
||
---|---|---|---|
Line 4: | Line 4: | ||
Pentru a crea tabelele si tabele similare cu denumiri in limba romana, se poate folosi acest {{:bd:resurse:baza_date.txt|fisier}}. | Pentru a crea tabelele si tabele similare cu denumiri in limba romana, se poate folosi acest {{:bd:resurse:baza_date.txt|fisier}}. | ||
- | ==== Documentatia SQL ==== | + | Structura tabelelor este prezentata in imaginea de mai jos: |
- | Documentatia SQL pentru Oracle Database 11g se gaseste la acest [[https://docs.oracle.com/cd/E11882_01/server.112/e41084/title.htm | link]], de unde poate fi descarcata in format [[https://docs.oracle.com/cd/E11882_01/server.112/e41084.pdf | pdf]]. | + | |
- | ==== Link-uri Oracle ==== | + | {{:bd:resurse:tabele_lab.png?600|}} |
- | [[https://livesql.oracle.com/apex/f?p=590:1000|Oracle Live SQL]] | + | ==== Documentatia SQL ==== |
- | + | Documentatia SQL pentru Oracle Database 19c se gaseste la acest [[https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/index.html | link]], de unde poate fi descarcata in format [[https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/sql-language-reference.pdf | pdf]]. | |
- | [[https://github.com/oracle/vagrant-boxes/tree/master/OracleDatabase|Download masina virtuala Vagrant]] | + | |
- | + | ||
- | [[https://www.oracle.com/technetwork/middleware/oedq/downloads/edq-vm-download-2424092.html|Download masina virtuala (.ova)]] | + | |
- | + | ||
- | [[https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html|Direct Software download]] | + | |
- | + | ||
- | ==== Comenzi utile ==== | + | |
- | * Lista cu tabelele la care are acces userul curent: | + | |
- | <code sql> select table_name from user_tables; </code> | + | |
- | * Coloanele unui tabel: | + | |
- | <code sql> desc <table_name>; describe emp; </code> | + | |
- | * Verificarea constrangerilor existente: | + | |
- | <code sql> | + | |
- | 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; | ||
- | </code> | ||
- | * Formatare afisare | ||
- | <code sql> | ||
- | set lines 100 | ||
- | set pages 100 | ||
- | </code> | ||