Re: V6 export to V5 DBMS

From: Michael Wang <mmwang_at_adobe.com>
Date: Sat, 29 Feb 1992 00:44:13 GMT
Message-ID: <1992Feb29.004413.12856_at_adobe.com>


In article <20828_at_venera.isi.edu> wpereira_at_ISI.EDU (Wallis Pereira) writes:
>
>Robin,
>
>A dump to the INSERT statement is one way, (the only way I know).
>
>Try this:
>
>SELECT 'INSERT INTO DEPT', ' VALUES (' || DEPTNO || ',' ||
> '''' || DNAME || '''' || ',' || '''' || LOC || ''''
> || ');'
>FROM DEPT;
>
>This results in:
>
>INSERT INTO DEPT
> VALUES(10, 'ACCOUNTING','NEW YORK');
You can shorten this somewhat:

SELECT 'INSERT INTO DEPT VALUES (', DEPTNO||','''||DNAME||''','''||LOC||        ''');'
FROM DEPT; Michael Wang
mmang_at_adobe.com Received on Sat Feb 29 1992 - 01:44:13 CET

Original text of this message