ORACLE: SQL JA PLSQL 12
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.txt 5
10020011 Id310 12-JUN-03 1 t2.txt 7
10020011 ID218 17-JUN-03 1 t3.txt 8
10020014 Iad307 01-JUN-03 1 t7.txt 10
annaabi.ee 
