On Wed, April 22, 2009 18:26, John wrote: > > can anyone please help... No gurus in this groups can suggest > something ? > > On Apr 22, 7:30 am, John <johnysm...@gmail.com> wrote: >> For a small automation project I have to extract data from a table/ >> tables and append it to the existing excel file and feed that excel >> file to a command that will load data into some other environment. I >> am totally new to this. So to get started I wanted to know, >> 1) How to extract data from sample table Foo which has columns A,B,C >> and append these values as new columns to an existing excel say >> fooresults.tsv ? >> 2) Can I achieve this in pl/sql script or do I need to write unix or >> perl script or some other programing language, please advise? >> >> Thanks a lot, >> John > > > I have a couple of thoughts on this
1) I don't normally think of a TSV file as being an Excel file except in the sense that Excel can read and write it. 2)you dont need PL/SQL to do this. My unix is a bit rusty so someone can correct me but wouldnt something like the following work from the unix command line? sqlplus < foo.sql >>fooresults.tsv Where foo.sql had something like select A||chr(9)||B||chr(9)||C from foo; plus appropriate login credentials ? also note that I probably didnt create a proper TSV file but I think that can be left as an exercise (^I is a tab isnt it?) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
