I have to fill a VARCHAR2 (2000)-field and my statement has 3400 characters. For now i cannot change the Datatype to a VARCHAR2 (4000)---internal problems! hmm...
I was thinking :
If i could replace the select, the where and from commands + make aliases for my column names and tables with 2 characters for an entire decode statement wich includes 36 selects i could shorten the statement to 2464 characters.
So anyway...its not enough ! Have to wait to change Datatype