Re: PL/SQL Execute Immediate

From: Richard Kuhler <noone_at_nowhere.com>
Date: Mon, 07 Apr 2003 22:30:07 GMT
Message-ID: <PZmka.31411$Hx.23136646@twister.socal.rr.com>

OraDev99 wrote:
>
> I am using Execute Immediate to dynamically create database triggers
> for all the tables in my application. Everything is working great
> creating the triggers but when I go look at the triggers it creates
> the whole thing on one line. Does anyone know how to incorporate a
> little bit of formatting even a carriage return where each line could
> be separate would be of great help?
>
> Thanks,

You should just be able to put newlines in yourself...

select 'line 1' || chr(10) || 'line 2' from dual

'LINE1'||CHR(

---

line 1
line 2

Richard Received on Mon Apr 07 2003 - 17:30:07 CDT