Re: PL/SQL Insert Into
Date: 1997/02/17
Message-ID: <5eai4q$pbm_at_hubcap.clemson.edu>#1/1
I'm not quite sure where the values you're inserting into EMP are coming from. If from another table, have you tried .... Insert into table EMP select * from table2.
If you're just wanting to produce a file w/ the INSERT INTO text, you may want to try dynamic sql. I'm not sure how many columns your table contains, but it may work.
If you're not familiar with dynamic sql and want some examples, let me know and I can send you some.
--JP
Janice Powell
Clemson University
In article <33039D2E.3F27_at_postoffice.worldnet.att.net>,
stranoj.dulcian_at_postoffice.worldnet.att.net says...
>
>I would like to write a PL/SQL function that would create INSERT INTO
>commands for each record of a given table. For example:
>
>DUMP('EMP') would produce:
>INSERT INTO EMP VALUES(7865,'SMITH',.....);
>
>Has anyone accomplished this or have any suggestions?
>
>Joe Strano
>Dulcian Inc.
Received on Mon Feb 17 1997 - 00:00:00 CET