Re: long insert-statement

Whilst not good practice, I believe you could write:

    insert into table2 t2
    select t1.*, 'insert',sysdate
    from table1 t1
    ;

Have to admit I haven't tried it myself but this type of syntax is legal elsewhere. Just be careful about the order of columns in the definitions.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Roland Kopetzky wrote in message
<7njkn9$rvm$1_at_infosun2.rus.uni-stuttgart.de>...
>Hello experts,
>
>I have a very wide table. It contains more than 100 attributes. Now I want
>to build a mirrored table and then I want to find out the differences
>between the tables. This would be easy using the minus function and writing
>the different attributes in a third table, the difference table.
>Now I want to add two columns to the difference table, a timestamp and the
>information whether the row has to be inserted, updated or deleted from the
>mirrored table to get them equivalent. I need the difference information
>somewhere else, therefore I can not build a new mirror-table, but I have to
>manage the changings.
>
>How can I write inserts like:
>Insert into differences values (attribute1,...., attribute100, sysdate,
>'insert');
>when the attributelist contains more than 100 attributes. Running this on
>Oracle 8 on NT, the worksheet can not manage insert-strings longer than 255
>characters.
>
>What is the solution for this?
>
>Yours sincerely
>
>Manfred Tischendorf (tischendorf_at_arkusa.de)
>
>
>
Received on Tue Jul 27 1999 - 02:40:59 CDT