SQL> SELECT * FROM view_union_name WHERE TO_CHAR(dated,'mm/yyyy') = TO_CHAR(SYSDATE,'mm/yyyy');
CMIIW Bowo --- In [email protected], m4z3 <[EMAIL PROTECTED]> wrote: > > Hi rekan2, > Saya mempunyai view union dr bbrp tabel yg isi recordnya spt dibawah: > > VENDOR_NO DATED ORDER_NO REL_NO SEQ_NO LIN_NO PART_NO TRAN_CODE IDR_PRICE DIRECTION Qty > IV0032 05/01/05 10256 1 1 1 A1 ARR-NONINV 46696212 + 2 > IV0032 28/02/05 10256 1 1 1 A1 SUPPPAY 46696212 - 2 > IV0032 05/01/05 10256 2 1 1 B5 ARR-NONINV 61859919.15 + 3 > IV0032 28/02/05 10256 2 1 1 B5 SUPPPAY 61859919.15 - 3 > IV0032 15/07/05 11213 1 1 1 R0 ARR-NONINV 61859919.15 + 1 > IV0032 30/07/05 11213 1 1 1 R0 SUPPPAY 61859919.15 - 1 > IV0032 30/07/05 21551 1 1 1 F1 ARR-NONINV 61859919.15 + 5 > IV0032 08/06/05 11111 1 1 1 F1 ARR-NONINV 61859919.15 + 8 > > saya ingin menghasilkan report misalkan > di bulan Juli 2005 (per akhir bulan) yg muncul > hanya record2 yg outstanding saja dan record2 yg tgl > transaksinya di bulan bersangkutan (Juli 2005), jd yg muncul > hanya record no 5, 6, 7 dan 8. > > Mungkin rekan2 bisa memberikan masukan mengenai > sintak sql atau pl/sql utk menghasil record2 > yg diingikan dg waktu eksekusi yg minimum. > > -- > m4z3 > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- 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/
