Differences
This shows you the differences between two versions of the page.
|
bd:resurse:tables [2019/02/28 13:48] maria_luiza.serban [Comenzi utile] |
bd:resurse:tables [2021/03/01 15:49] (current) ciprian.truica [Documentatia SQL] |
||
|---|---|---|---|
| Line 2: | Line 2: | ||
| ==== Tabele ==== | ==== Tabele ==== | ||
| - | Pentru a crea tabelele existente in schema user-ului Scott (emp, dept, bonus, salgrade), se poate folosi acest [[https://github.com/oracle/dotnet-db-samples/blob/master/schemas/scott.sql | script]]. Alternativ, pentru a crea aceste tabele 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'; | ||
| - | </code> | ||
| - | * Formatare afisare | ||
| - | <code sql> | ||
| - | set lines 100 | ||
| - | set pages 100 | ||
| - | </code> | ||
