I have got mostly everything working when I attempted this except for one
obstacle I cant seem to work around..
I need to have the statement:-
select table_name|| ',' from all_tables where table_name like 'T%' and owner =
'ARADMIN' order by table_name;
appended to a .sql file when I run a MS-DOS batch file..
I tried:-
echo select table_name|| ',' from all_tables where table_name like 'T%' and
owner = 'ARADMIN' order by table_name;>>C:\test.sql
However DOS thinks that the statement is terminated after the first |
character, thus it echos "select table_name to the screen and ignores the rest
of the line..
I have tried escaping the | character with a \ but that doesn't do the trick.
Anyone has any brainwaves on how I might be able to overcome this??
Thank you
Joe
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
