Skip to Content
avatar image
Former Member

Dynamic SQL over multiple lines - possible?

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers