Skip to Content
1

Dynamic SQL over multiple lines - possible?

Nov 09, 2017 at 06:28 AM

11

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers