Oracle: SQL ja PLSQL 01
1. Logige Oracle�i andmebaasi �testdata� k�lge kasutajanimega scott ja parooliga
tiger.
Enter user-name: scott
Enter password:
Last Successful login time: Sun Mar 05 2017 01:20:23 +02:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing oions
2. Uurige, milline on tabeli kandidaadid struktuur.
SQL> DESCRIBE kandidaadid
Name Null? Type
----------------------------------------- -------- -------------------------
ID CHAR(11)
EESNIMI VARCHAR2(20)
PERENIMI VARCHAR2(30)
MATEMAATIKA NUMBER(3)
annaabi.ee 
