RE: simple sql problem

From: Nirmal Kumar Muthu Kumaran <NIRMALK_at_qtel.com.qa>
Date: Mon, 03 Dec 2001 23:17:57 -0800
Message-ID: <F001.003D42FC.20011203220019@fatcity.com>

Hi...

You cann't run sql statement in command line directly However you can in case of script file.

Make the query as a script file.  Then run it on SQLPLUS.

• c:\test.sql

  ---

  select * from emp / exit /

  ---

c:\> sqlplus -s scott/tiger_at_oranir @c:\test

This will work.

HTH. Rgds,
Nirmal,
-----Original Message-----

From:   Viraj Luthra [SMTP:viraj999_at_lycos.com]
Sent:   Tuesday, December 04, 2001 8:11 AM
To:     Multiple recipients of list ORACLE-L

Subject:        simple sql problem

Hello all,

Why cannot I do :-

sqlplus -s scott/tiger select * from emp;

or sqlplus -s scott/tiger "select * from emp;"

Both the cases I get :-

Usage: SQLPLUS [<option>] [<user>[/<password>] [@<host>]]    
               [@<startfile> [<parm1>] [<parm2>] ...]        
where <option> ::= { -s | -? }                               

-s for silent mode and -? to obtain version number          

What is wrong above? I need to run the query from command line. How do I modify this :-

sqlplus -s scott/tiger select * from emp;

Rgds,

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Viraj Luthra
  INET: viraj999_at_lycos.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).  You may also send the HELP command for other information (like subscribing). Received on Tue Dec 04 2001 - 01:17:57 CST