Re: Sqlplus for Windows

On Mon, 25 Mar 2002 18:36:26 +0100, Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:
>The convention is to use the DOS variant of sql*plus in .BAT files
>so plus33.exe

oh ok, because it behaves more like unix sqlplus?

>(You'd better not use hardcoded execution paths in your
>.BAT, please make sure your PATH is correct

Yeah, just laziness on my part :)

>and I don't see why you are using start, that isn't necessary either)

I was using start because the command window disappears once the GUI starts, instead of hanging around. If I should use the command line sqlplus though, then start is indeed unnecessary.

>The default database can be set using the LOCAL environment variable
>or string value in HKLM\software\oracle, to the service name in your
>tnsnames.ora

Thanks.

>You can always use ops$ accounts, so you can connect using a / only,
>so no security hole.

Hmm, I'm using a remote database, which precludes the use of ops$, doesn't it? Anyway, the powers that be here are very paranoid about security and would probably keel over clutching their chest at the suggestion of using ops$ accounts. Received on Mon Mar 25 2002 - 19:10:27 CET