Hello World. This is my First of First Blog. Here I will try to write things related to what I learn, Since I am kinda obsessed with Technology’s lineage. I, being a Java professional, love Java profoundly and so tried to make a blog that will help you and me of course to be in touch with new happenings in the field of technology. I may soon start a discussion forum based on Java, for that we need to wait a while, after all , not always, good things are FREE….
Create the file buy_export.sql:
set echo off
set feedback off
set linesize 100
set pagesize 0
set sqlprompt ''
set trimspool on
spool buyInfo.csv
select buyid||','|| name
from dbbuy;
spool off
Run it using
sqlplus -S [username]/[password]@[SID] @buy_export.sqlSphere: Related Content
Posts
1 comments:
hi.. i beginner here.need help.
i got csv file. i can load the csv file into stringgrid using delphi. now i want that csv file been insert to table. i'm using oracle 9i.
Post a Comment