Home › Discussions › Questions & Answers › Is there a possibility to have column names in capital letters?

Is there a possibility to have column names in capital letters?

Avatar photoCustomer Questions & Answers 2 replies

Hi everyone,

Is there a possibility to have column names in capital letters?

I have the following select statements in my query

c.ap_status

AP_STATUS,

to_char(geps_po_rm_del_avt.geps_po_cnv_date(c.last_update_date),

‘DD-MM-YYYY HH24:MI:SS’) AP_CLOSING,

d.ar_status

AR_STATUS,

to_char(geps_po_rm_del_avt.geps_po_cnv_date(d.last_update_date),

‘DD-MM-YYYY HH24:MI:SS’) AR_CLOSING,

e.fa_status

FA_STATUS,

to_char(geps_po_rm_del_avt.geps_po_cnv_date(e.last_update_date),

‘DD-MM-YYYY HH24:MI:SS’) FA_CLOSING

 

Thus the alias are in capital letters.

Thank you in advance.

2 replies

  • Artem Nesterko Enginatics

    Hi,

    This is due to the automated column translation feature, which would not just convert an UPPER_CASE_COLUMN to a more readable Upper Case Column. This feature also translates some of the most common column names to local language, in case a user is logged on with a different language than US.

    You can disable this translation with the options checkbox.

    Alternatively, if you do not require the underscore, you can do the following:

    select

    aps.vendor_name “VENDOR NAME”

    from

    ap_suppliers aps

    Or, if you don’t mind having an extra space in the excel cell:

    select

    aps.vendor_name “VENDOR_NAME ”

    from

    ap_suppliers aps

    Let me know if this works for your requirement.

    Attachments:

    1. 1-5.png

  • Avatar photoCustomer

    Thank you very much for the quick reply and the detailed explanation. One of the option will definitely work for us. I will check with the user what she prefers.

  • You must be logged in to reply to this post.