Re: Urgent Help

hi,

1. what do u mean by run a batch file of SQL? if you just want to run a group of queries, you can just type these queries in a text file and save it with extension .SQL (not compulsory). once u do that, at the SQL prompt just type _at_filename your queries will be executed. in case u have given an extension other than .SQL, you will have to type _at_filename.extension. if the file is not saved in the same directory as ur Start Directory for SQL PLUS, you will have to give the full path i.e. _at_path\filename
2. u using oracle under what environment? if it's windows, then go to regedit, under HKEY_LOCAL_MACHINE expand SOFTWARE and then expand ORACLE. add a new key NLS_DATE_FORMAT and give the value as mm/dd/rrrr

hope this helps.

regards
aparna

"iqbalkhan1" <iqbalkhan1_at_email.msn.com> wrote in message news:uZm5BSajAHA.269_at_cpmsnbbsa07...
> Hi Group,
> 1. How can I write a batch script for SQL. I want to run a several
> queries and want to put into a batch file. Will anyone help me.
>
> 2. I want to create a date column as mm/dd/yyyy. I tried to set the
> nls_date_format at init.ora; but never solved my problem.
>
> Thanks
>
>
Received on Tue Feb 06 2001 - 11:17:37 CET