RE: Re: SQL Question

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Tue, 28 Jan 2003 04:48:39 -0800
Message-ID: <F001.0053BF3B.20030128044839@fatcity.com>

('binary' encoding is not supported, stored as-is)
The first query also says 'from user_group_members' and the second one 'from app_users' ... I am not sure that the comparison is anything but confusing ...

Looks like the implicitly converted varchar2() column which contains '***', 'N/A' or the like ...

>
>The first query says "where FK_USER in
>(44541,41402,41813)" and the second
>query says "where PEN_ID in (44541,41402,41813)"...
>
>
>----- Original Message -----
>To: "Multiple recipients of list ORACLE-L"
><ORACLE-L_at_fatcity.com>
>Sent: Monday, January 27, 2003 11:43 PM
>
>
>> Hi,
>>
>> My brain is slow today.... Can someone help me ?
>>
>> I can do :
>>
>> select idu+1 from user_group_members where
>fk_user
>> in(44541,41402,41813) ;
>>
>> IDU+1
>> ----------
>> 41411
>> 41821
>> 44546
>>
>> But I can't do :
>> select 'insert into XXX
>(IDU,PEN_ID,LAST_ACCESS,FK_APPLICATION) values
>('||IDU + 1
>||','||PEN_ID||',sysdate,'||FK_APPLICATION||');'
>from app_users
>> where pen_id in (44541,41402,41813) ;
>>
>> I've got on IDU+1 :
>>
>> ERROR at line 1:
>> ORA-01722: invalid number
>>
>>
>> Best Regards
>> Henrik
>>
>> --
>>
>-
>> There's fun in being serious.
>>
>> -- Wynton Marsalis
>>
>> Henrik Ekenberg
>Anoto AB
>>
>>
>> --
>> Please see the official ORACLE-L FAQ:
>http://www.orafaq.net
>> --
>> Author: Henrik Ekenber
>> INET: henrik.ekenberg_at_anoto.com>"
><henrike_at_anoto.com
>>
>> Fat City Network Services -- 858-538-5051
>http://www.fatcity.com
>> San Diego, California -- Mailing list and
>web hosting services
>>
>> 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).
>>
>
>--
>Please see the official ORACLE-L FAQ:
>http://www.orafaq.net
>--
>Author: Tim Gorman
> INET: Tim_at_SageLogix.com
>
>Fat City Network Services -- 858-538-5051
>http://www.fatcity.com
>San Diego, California -- Mailing list and
>web hosting services
>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).
>---------------------------------------------------
>-----------------------
>---------------------------------------------------
>------------------
>---------------------------------------------------
>------------------

Regards,

Stephane Faroult
Oriole

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroul
  INET: sfaroult_at_oriolecorp.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Jan 28 2003 - 06:48:39 CST