Re: how do run sql from the command line with embedded sql

Even better:

sqlplus <<!
scott/tiger_at_service
select * from emp;
exit
!

This took the scott/tiger user/password off the command line where it may be visible to other users via the ps command.

Denis Scholler wrote:

> RABK wrote:
>
> > how do i run embedded sql from a unix shell
> >
> > kindah as such
> >
> > sqlplus SYS/MANAGER_at_service @<<!
> >
> > select * from DUAL;
> >
> > !
>
> It is as simple as :
>
> sqlplus scott/tiger_at_service <<!
> select * from emp;
> exit
> !
Received on Fri Apr 09 1999 - 23:29:10 CDT