Thanks that solved the problem
Regards
Henrik
--
---------------------------------------------------------------------------
Henrik Ekenberg Anoto AB
On Tue, 28 Jan 2003, Johan Malmberg wrote:
-!-You might want to try using () around the "idu+1" part!
-!-
-!-like:
-!-
-!-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) ;
-!-
-!-That should do it!
-!-
-!-Best Regards
-!-Johan
-!-
-!-
-!-
-!-> -----Ursprungligt meddelande-----
-!-> Fran: root_at_fatcity.com [mailto:root_at_fatcity.com]For Henrik Ekenberg
-!-> <henrik.ekenberg_at_anoto.com>
-!-> Skickat: den 28 januari 2003 07:44
-!-> Till: Multiple recipients of list ORACLE-L
-!-> Amne: SQL Question
-!->
-!->
-!-> 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: 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).
Received on Tue Jan 28 2003 - 06:13:53 CST
