Coba dibuat query ini SELECT substr(masa,3,2) bulan, substr(masa,5,4) tahun from nama tabelnya
Semoga berhasil 2010/2/16 max_rif <[email protected]> > > > Mohon maaf newbie ni.. > > Saya punya data misalnya seperti ini : > > | masa | > | 01122005 | > > keterangan : > ------------- > pembayaran untuk masa januari s.d desember 2005 > > bagaiamana querynya agar datanya jadi seperti ini > > | bulan |tahun > | 01 |2005 > | 02 |2005 > | 03 |2005 > | 04 |2005 > | 05 |2005 > | 06 |2005 > | 07 |2005 > | 08 |2005 > | 09 |2005 > | 10 |2005 > | 11 |2005 > | 12 |2005 > > NB : > user tidak di ijikan untuk menjalankan perintah > CREATE, DELETE, UPDATE > > terima kasih > > > -- ================================= Terima kasih Salam, Domintan Siagian [Non-text portions of this message have been removed] ------------------------------------ -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [email protected] Website: http://indooracle.wordpress.com http://www.facebook.com/group.php?gid=51973053515 ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.comYahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> 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/
