Even using like this:- echo "select * from v$instance;" | sqlplus system/manager
gives me the error :- SQL> select * from v * ERROR at line 1: ORA-00942: table or view does not exist Though I can do the same sql statement from inside sqlplus with ease, so why does it give table or view does not exist? I am confused .. rgds, -- On Mon, 03 Dec 2001 21:50:17 Ross Collado wrote: >I don't believe SQLPlus will let you run a SQL statement in the command line >itself. As you can see in Usage:, it doesn't have an option for this. >However, if you insist on running SQL statements in the command line itself, >you can probably do something like (only in Unix): > >sqlplus -s scott/tiger << ! >select * from emp; >! > >or > >save your select * from emp; to a sql file and do : >sqlplus -s scott/tiger @myfile.sql > >hth >Ross > >> -----Original Message----- >> From: Viraj Luthra [mailto:[EMAIL PROTECTED]] >> Sent: Tuesday, 4 December 2001 16:11 >> 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: [EMAIL PROTECTED] >> >> 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: [EMAIL PROTECTED] (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). >> >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Ross Collado > INET: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).