Home » RDBMS Server » Server Administration » Re: SQL*PLUS default path
Re: SQL*PLUS default path [message #373255] Fri, 06 April 2001 08:32 Go to next message
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi,

Keep all the files in some dir you want.
and then go to dos prompt(command)
cd to your directory. From there launch either plus or plusw(look for the exact exe name under oracle/bin)

then you run your sqls in that directory
by just calling them like

C:> cd myscripts
C:\myscripts> plusw userid/pw@db1

SQL> @script1

Bala.

Report message to a moderator

Re: SQL*PLUS default path [message #374881 is a reply to message #373255] Mon, 09 July 2001 15:30 Go to previous messageGo to next message
Eva
Messages: 16
Registered: July 2001
Junior Member
Do you know how to do this with Windows 2000?

Thanks,
Eva

Report message to a moderator

Re: SQL*PLUS default path [message #374894 is a reply to message #373255] Tue, 10 July 2001 07:42 Go to previous message
Bala
Messages: 205
Registered: November 1999
Senior Member
Same way.
If you have oracle 8.1.x then the name of the exe is sqlplus
so
C:\myscripts> sqlplus
SQL> @script1

Report message to a moderator

Previous Topic: Re: Help with an Oracle SQL Statement
Next Topic: Count of the records of a table!!!!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 19:32:39 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.