Dynamic SQL over multiple lines - possible?

[former_member290786]

Hello,

I've created a procedure that in one of it's steps - selects around 80 columns from a table into a CREATE VIEW statement.

Currently, the procedure concatenates the string in 1 line of code.

----------------------

I know that if I have

'SELECT * FROM X'

I can break it into

'SELECT * ' ||

'FROM X'

So my question is whether it's possible to pull a line continuation without having to open and closing the string again with a quote sign?

Thanks,

Or.