On Aug 14, 1:34 am, Karthikeyan R <karthi...@gmail.com> wrote:
> Is there a way to mask password while entering it?
>
>
>
>
>
> On Fri, Aug 14, 2009 at 10:01 AM, Karthikeyan R <karthi...@gmail.com> wrote:
> > Thank you Mr.David,
>
> > I have changed a bit & used it like this.
>
> > set user=%1
> > set pass=%2
> > set Tnsname=%3
> > sqlplus %user%/%pa...@%tnsname% <%25user%25/%25pass...@%25tnsname%25>
>
> > On Fri, Aug 14, 2009 at 12:58 AM, ddf <orat...@msn.com> wrote:
>
> >> On Aug 13, 1:45 pm, ddf <orat...@msn.com> wrote:
> >> > On Aug 13, 11:24 am, Karthikeyan R <karthi...@gmail.com> wrote:
>
> >> > > Hi,
>
> >> > > I need to write a batch file which would accept parameters & then
> >> > > login to Oracle and then I need to run a sql file (for ex: test.sql)
>
> >> > > I used to connect it by using the following text
> >> > > sqlplus username/passw...@sid @test.sql
>
> >> > > But I have to get username, password & sid as parameters in the
> >> command prompt.
>
> >> > > can someone help me out in doing this?.
>
> >> > > --
> >> > > Thanks & Regards,
> >> > > Karthikeyan
>
> >> > connect.bat:
>
> >> > sqlplus %%1/%...@%%3
>
> >> > Add whatever script you want at the end of that line.
>
> >> > David Fitzjarrell
>
> >> I have too many % in that command; the correct syntax is:
>
> >> sqlplus %1/%...@%3
>
> >> My apologies.
>
> >> David Fitzjarrell
>
> > --
> > Thanks & Regards,
> > Karthikeyan
>
> --
> Thanks & Regards,
> Karthikeyan- Hide quoted text -
>
> - Show quoted text -
Not the way you want it to work, no. You COULD change your
'requirement' and code the login into a separate connect.sql script
but that would eliminate the possibility of choice for the user
running the batch file.
David Fitzjarrell
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
