Gunakan perintah 'execute immediate' mis. isian tahun di field :block.item (tipe varchar2) Perintah menjadi Execute immadiate 'select * from table'||:block.item;
rgds, AWAL ----- Original Message ----- From: agus purwanto To: [email protected] Sent: Tuesday, June 20, 2006 8:42 AM Subject: [indo-oracle] How To In Form .. Dynamic Table ? Salam, bagaimana membuat form agar block yang kita pake sesuai dengan keinginan kita, selama ini block tersebut kita set pada saat membuat form. ini saya gunakan untuk mengacu ke table agar bisa pertahun ? contoh : table2005, table2006 saya ingin melihat data tahun 2005 select * from table&tahun; --> secara logika seperti itu, syntax itu jalan di sqlplus. Tapi bagaimana kalo di Form Builder ya ? terima kasih ags Nb : Oracle Developer 6.0 --------------------------------- Yahoo! Groups gets better. Check out the new email design. Plus there's much more to come. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Something is new at Yahoo! Groups. Check out the enhanced email design. http://us.click.yahoo.com/SISQkA/gOaOAA/yQLSAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.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/
