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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
