Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2011
    Posts
    6

    Unanswered: abbreviations sql commands

    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!

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    No, there is no such thing.

    Why do you need to shorten your statement?

  3. #3
    Join Date
    Oct 2011
    Posts
    6
    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

  4. #4
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    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

  5. #5
    Join Date
    Oct 2011
    Posts
    6
    Yes you are right! Maybe it can get larger!

    will go for the CLOB!

    thnx

  6. #6
    Join Date
    Dec 2008
    Location
    At work...
    Posts
    92
    Talking bout abbreviations, here we got VARCHAR which is the short form for CHARACTER VARYING, and CLOB which stands for CHARACTER LARGE OBJECT.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •