ORACLE: SQL JA PLSQL 12
SQL> SPOOL
currently spooling to ülesanne_12.lst
SQL> CREATE TABLE koduylesanded AS (SELECT * FROM scott.koduylesanded);
Table created.
SQL> COLUMN yliopilase_id FORMAT 999
SQL> COLUMN kursusekood FORMAT A8
SQL> COLUMN too_nr FORMAT 999
SQL> COLUMN yliopilase_id FORMAT 999
SQL> COLUMN punktid FORMAT 999
SQL> COLUMN failinimi FORMAT A8
SQL>
SQL> SELECT * FROM koduylesanded;
YLIOPILASE_ID KURSUSEK KUUPAEV TOO_NR FAILINIM PUNKTID
------------------------ -------- --------------- ------ -------- -------
10020014 I319 01-JUN-03 1 t7.txt 10
10020015 I319 11-JUL-03 1 t8.txt 10
10020011 I319 11-JUN-04 2 t2.txt 7
10020013 I319 11-JUN-04 3 t3.txt 8
10020011 Iad307 11-JUN-03 1 t1
annaabi.ee 
