Re: problems creating script of insert statements
From: Joe Mellors <joemellors_at_aol.com>
Date: 20 Jan 2002 12:30:20 -0800
Message-ID: <53566469.0201201230.8135980_at_posting.google.com>
Date: 20 Jan 2002 12:30:20 -0800
Message-ID: <53566469.0201201230.8135980_at_posting.google.com>
> Hi Joe,
> I think you can do that without PL/SQL.
> Just Replace "commit" in your Insert statement with "'||chr(10)||'commit'"
> This shall do the trick. Chr(10) is the carriage return character
>
> -- Anand
>
Thanks Anand and Darren. I did get what I wanted using the UTL_file in the end but its good to know about chr(10). Cheers for the help !
Regards,
Joe Received on Sun Jan 20 2002 - 21:30:20 CET