Jared,

Using the 2nd option:-

sqlplus system/manager@orcl815 <<! 
SELECT a.username,  substr(sql_text,1,100), substr(sql_text,101,250),
substr(sql_text,601,250),substr(sql_text,851,250),
substr(sql_text,1101,250) 
FROM sys.dba_users a, v$session, v$sqlarea
where parsing_user_id=user_id AND address=sql_address(+)
and sid=15
!

I get nothing, like I get this :-

SQL*Plus: Release 8.1.5.0.0 - Production on Tue Dec 4 17:31:01 2001                    
         
                                                                                       
         
(c) Copyright 1999 Oracle Corporation.  All rights reserved.                           
         
                                                                                       
         
                                                                                       
         
Connected to:                                                                          
         
Oracle8i Release 8.1.5.0.0 - Production                                                
         
With the Java option                                                                   
         
PL/SQL Release 8.1.5.0.0 - Production                                                  
         
                                                                                       
         
SQL>   2    3    4    5    6    7  Disconnected from Oracle8i Release 8.1.5.0.0 - 
Production    
With the Java option                                                                   
         
PL/SQL Release 8.1.5.0.0 - Production                                                  
         



But if I use the 1st option :-

eg

echo "SELECT a.username,  substr(sql_text,1,100), 
substr(sql_text,101,250),substr(sql_text,601,250),substr(sql_text,851,250),
substr(sql_text,1101,250)
FROM dba_users a, v$session, v$sqlarea where parsing_user_id=user_id AND 
address=sql_address(+)
and sid=15;"|sqlplus system/manager

I get this error:-

SQL>   2    3    4  FROM dba_users a, v, v where parsing_user_id=user_id AND 
address=sql_address(+)      
                     *                                                                 
                  
ERROR at line 3:                                                                       
                  
ORA-00942: table or view does not exist                                                
                  
                                                                                       
                  

But if I execute the query on its own, I get proper results.

So in both cases I am not able to get results.

What am I doing wrong?

Rgds,
--

On Mon, 3 Dec 2001 21:38:36   
 Jared Still wrote:
>
>The way you're doing it sqlplus is trying to parse the SQL 
>as a command line argument, which will not work.
>
>Try these:
>
>1.
>
>echo "select * from dual;" | sqlplus scott/tiger
>
>2.
>
>sqlplus scott/tiger <<EOF
>select * from dual;
>EOF
>
>Jared
>
>
>On Monday 03 December 2001 21:10, Viraj Luthra wrote:
>> 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).

Reply via email to