Gita cantiq <[EMAIL PROTECTED]> wrote: hay Gta,
sya aul dr bandung saya juga biasa pk form6i.
biasa nya klo mau export ke excel saya jg pke button pressed :
HOST('C:\DFILE.BAT');
HOST('C:\orawin95\BIN\SQLPLUS user/[EMAIL PROTECTED] @C:\SPL_OTK.SQL
'||parametertgl1||' '||parametertgl2);
SPL_OTK.SQL = ini file dll yg saya buat
contoh nya seperti ini: SET SERVEROUTPUT ON
SET LINE 290
SET HEADING OFF
SET PAGES 2000
SET VERIFY OFF
SELECT A.X||';'||
FROM OTK A
WHERE (B.AGENT_ID = A.AGENT_ID) AND (C.REGIONAL_CODE = B.REGIONAL_CODE) and
TO_CHAR(DATE_OF_OTK,'YYYYMMDD') BETWEEN '&&1' and '&&2'
ORDER BY 1;
SPOOL C:\OTK.TXT; (ini alamat file txt keluarannya)
/
SPOOL OFF;
EXIT;
klo buat import saya biasa pake sqlloader
__________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search.
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
[Non-text portions of this message have been removed]
---------------------------------
Never miss a thing. Make Yahoo your homepage.
[Non-text portions of this message have been removed]
