Re: Generating SQL script for table filling

Hi Jan,

How about

SELECT 'INSERT INTO <table_name> VALUES ('||col_1||','col_2');' FROM <table_name>;

I know it is a pain in the nect to write this select statement, but I think it will do what you want.

Regards

Jerry

Jan Januska wrote:
>
> Please,
> How do I get quickly (using some tool or script) a SQL script containing
> INSERT commands that fill table.
> Value to insert must be taken from current contain of the table in
> database.
> In other words, I want to export a table in SQL-like dump.
>
> Thanks for help, Jan Januska

--

Jerry Gitomer         	ICT Group
jgitomer_at_ictgroup.com	Langhorne PA
jgitomer_at_yahoo.com 	Opinions are mine not those of ICT Group