Hi There,

are there abbreviations of the commands in sql. For example select = slt or from = fr or something similar.

i need to get a statement shorter!

Thank you very much!

No, there is no such thing.

Why do you need to shorten your statement?

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

Thanks for reading

If you change the datatype go for a CLOB right away. Otherwise I wouldn't be surprised if you need another workaround once you hit the 4000 characters limit

Yes you are right! Maybe it can get larger!

will go for the CLOB!

thnx

Talking bout abbreviations, here we got VARCHAR which is the short form for CHARACTER VARYING, and CLOB which stands for CHARACTER LARGE OBJECT.