kalo anda anda pake ASA saya yakin anda pasti pake Power builder!
1. dari PB > DBAdmin > ISQLSession >
jalankan SQL COmmand :

misal : select * from DBA.table_name atau select * from DBA.view_name

2. pidah ke tabpage Output:
akan muncul row data dari perintah diatas.

3. pilih menu Row > Save Row As > : pilih Save As type SQL
PowerBuilder akan men"Generate" DML & DDL statement
Create .... &
Insert into.....

4. Tinggal mengexecute file.SQL tadi pada COnsole Oracle (SQLPLUS / SQLPLUSW)
sql>@path\nama_file.sql

* untuk database object yg lain (function, trigger) saya masih
melakukan dgn re-coding.

mudah2an membantu.

regards
IKS


------------------------ Yahoo! Groups Sponsor --------------------~--> 
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/KIlPFB/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/
 


Kirim email ke