Gunakan perintah SQL*Plus "COLUMN"

SQL> COLUMN kode_matkul FORMAT A12
SQL> COLUMN nilai FORMAT 99999

setelah itu baru jalankan perintah SELECT ...

Bowo

--- In [email protected], "Surya A. Saputra" 
<[EMAIL PROTECTED]> wrote:
> Dear Indo,
> 
> NIM        KOD NIL
> ---------- --- ---
> 0311500257 p01 75
> 0311500257 i01 100
> 0311500257 w01 85
> 
> Bisa ga tampilan di SQL*Plus menjadi seperti ini :
> 
> NIM        KODE_MATKUL NILAI
> ---------- ----------- -----
> 0311500257 p01         75
> 0311500257 i01         100
> 0311500257 w01         85
> 
> sesuai dengan nama record aslinya karena panjang kode_matkul dan 
nilai hanya
> saya set 3.
> Thanks atas bantuannya.
> 
> Best regards,
> Surya A. Saputra
> 
> Stop bunuh diri !! Hidup anda teramat berharga untuk disia-siakan 
> http://groups.yahoo.com/group/be-friends





--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
-----------------------------------------------

Bergabung dengan Indonesia Thin Client User Groups, 
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/indo-oracle/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 


Kirim email ke