This shows you the differences between two versions of the page.
bd:resurse:tables [2019/02/23 13:30] iulia.radulescu [Link-uri Oracle] |
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]] | + | |
- | + | ||
- | [[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]] | + | |
- | + | ||
- | ==== Tutoriale Oracle Virtualbox ==== | + | |
+ | ==== 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://www.cyberciti.biz/faq/how-to-install-virtualbox-on-fedora-linux/|Instalare pe Fedora]] | ||
- | [[https://www.linuxtechi.com/install-virtualbox6-ubuntu-18-04-centos-7/|Instalare pe Ubuntu 18.04/18.10/CentOS 7]] | ||