Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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>​ 
  
  
bd/resurse/tables.1551806680.txt.gz · Last modified: 2019/03/05 19:24 by ciprian.truica
CC Attribution-Share Alike 3.0 Unported
www.chimeric.de Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0