Re: PL/SQL
Date: Thu, 26 Oct 2000 09:30:46 +0200
Message-ID: <39f7d00d$1_at_miik2-ilt.ilt.kharkov.ua>
You needed use Native SQL or Dynamic SQL
Pascal Schneider <pascal.schneider_at_systor.com> wrote in message
news:39F6CEDE.4B1CF571_at_systor.com...
> Hi,
>
> Could somebody help me to write a Store procedure wich read all table
> name from tab
> (CURSOR C1 IS SELECT TNAME FROM TAB WHERE TABTYPE ='TABLE' AND TNAME <>
> 'MIGRATE';)
> and use this TNAME to select each ROWID for each table (SELECT
> 0,SEQ_TEST.NEXTVAL,ROWID,SYSDATE,'INSERT',:TNAME FROM :TNAME;)
> and finaly insert the result in a table named MIGRATE:
> 'INSERT INTO MIGRATE (SELECT
>
>
0,SEQ_TEST.NEXTVAL,ROWID,SYSDATE,'||'"INSERT"'||','||'"'||TABLE_NAME||'"'||'
>
> FROM
>
> '||TABLE_NAME||')';
>
> My Mail: pascal.schneider_at_systor.com
>
> Thank's
>
Received on Thu Oct 26 2000 - 09:30:46 CEST