SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to get a column alias name more than 30 characters length

ChaitanyaGoparajuAug 19 2011 — edited Aug 19 2011

Hi All,

Is there any way I can get an alias name with length > 30 characters? I am selecting data from a table and writing it in a file. the column names, as per the requirement, are longer than 30 characters.

Please find below a sample query from my code

SELECT COUNT(*) "Total users logged in for the reporting time period = " FROM (SELECT DISTINCT USERID, ACCOUNTNUMBER FROM TABLE_XXX WHERE ACCOUNTNUMBER = 'ABC123' AND LOGINDATE BETWEEN TO_DATE('01-JUN-2011') AND TO_DATE('31-JUL-2011'))

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 16 2011

Added on Aug 19 2011

5 comments

8,689 views