Xref: alice comp.databases.oracle.server:45531
Path: alice!news-feed.fnsi.net!netnews.com!newspeer.monmouth.com!isdnet!uu.fr!inetway.net!not-for-mail
From: Denis Scholler <doeni@evhr.net>
Newsgroups: comp.databases.oracle.server
Subject: Re: how do run sql from the command line with embedded sql
Date: Fri, 09 Apr 1999 20:58:36 +0200
Organization: UUNet
Lines: 21
Message-ID: <370E4DDC.33E55E12@evhr.net>
References: <01be82c7$0a7d7710$8f36a8c0@ctmnnt022b>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: jaydee.iway.fr 923689085 5296 212.208.236.28 (9 Apr 1999 20:18:05 GMT)
X-Complaints-To: abuse@iway.fr
NNTP-Posting-Date: 9 Apr 1999 20:18:05 GMT
X-Mailer: Mozilla 4.5 [en] (X11; I; Linux 2.0.35 i686)
X-Accept-Language: en

RABK wrote:

> how do i run embedded sql from a unix shell
>
> kindah as such
>
> sqlplus SYS/MANAGER@service  @<<!
>
> select * from DUAL;
>
> !

It is as simple as :

sqlplus scott/tiger@service <<!
select * from emp;
exit
!