Look into http://www.itsystems.lv/gints/dba_selects.htm#s21
It seems exactly what You need Gints Plivna IT Sist�mas, Mer�e�a 13, LV1050 R�ga http://www.itsystems.lv/gints/ Janet Linsy <janetlinsy@yahoo To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> .com> cc: Sent by: Subject: generate insert statement ??? [EMAIL PROTECTED] 2002.09.11 01:12 Please respond to ORACLE-L Hi all, I need to generate insert statements for a given table. For example ACCOUNTING_TRANSACTION_TYPE table has 300 rows, and I need to generate a sql like the following: INSERT INTO ACCOUNTING_TRANSACTION_TYPE (ACCT_TRAN_TYP_CD, ACCT_TRAN_TYP_NM, GL_ACCT_TYP_CD, ACCT_TRAN_TYP_GL_IND, ACCT_TRAN_TYP_VOID_IND) VALUES ('wrtn_prem', 'Written Premium', '109200_401600', 'y', 'n'); .... insert blocks for the rest rows Are there any easy way to handle this? Thank you in advance! Janet __________________________________________________ Yahoo! - We Remember 9-11: A tribute to the more than 3,000 lives lost http://dir.remember.yahoo.com/tribute -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
