generate insert statement ???

From: Janet Linsy <janetlinsy_at_yahoo.com>
Date: Tue, 10 Sep 2002 14:04:43 -0700 (PDT)
Message-Id: <22528.293399@fatcity.com>

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 Received on Tue Sep 10 2002 - 16:04:43 CDT