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 December 27, 2024 at 2:06 pm

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.

Viewing 1 reply thread
  • Author
    Replies
    • Artem Nesterko December 28, 2024 at 12:36 pm  

      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:
    • Avatar photoCustomer December 29, 2024 at 6:08 pm  

      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.

Viewing 1 reply thread
  • You must be logged in to reply to this post.

Login with: