Re: DSN in SQL Plus line?

I've seen an example in UNIX in which the USER and PASSWORD are set as variables, then passed to your script, e.g.,

USER = scott; export USER
PWD = tiger; export TIGER
SQLPLUS $USER/$PWD@$ORACLE_SID <<EOF
code
exit
EOF HTH,
Dave Van Zandt
Alcoa

Robert Wagner wrote:
>
> OK, here's one more question:
>
> How do I handle it when I know the DSN but _don't know_ the username. For
> example, I ship the batch and script files to my customer, but I don't know
> who's actually going to be using them.
>
> Thanks again >>>> Robert
>
> "David Van Zandt" <dvanzandt_at_iquest.net> wrote in message
> news:39423B17.97C1BE13_at_iquest.net...
> > Unless I'm missing something obvious, you're omitting the
> > username/password (prior to the @ROBERT).
> >
Received on Mon Jun 12 2000 - 00:00:00 CDT