Skip to Content
author's profile photo Former Member
Former Member

Column Heading more than 30 char

Hi,

In query template I am getting the column names dynamically, I want to show Alias instead of column names but in Oracle, column Alias has a limit of 30 char.

How can I show the Alias with more than 30 char in Query Template? I need to export the output of Query to Excel and HTML.

Thanks,

Anil

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Mar 19, 2008 at 03:33 AM

    Hi Anil,

    You could use an inline transform by applying an XSL stylesheet. You could specify the long alias in the stylesheet itself.

    Alternatively, you could use a Business Logic Transaction. It has a Column Alias Action Block. The output of the Column Alias Action Block would be linked to a Transaction Output Property.

    The data flow will be as follows:

    Datasource - Query Template 1 - Transaction with Column Alias Action Block - Query Template 2 - Excel/HTML

    Query Template 1 will be of Type SQL.

    Query Template 2 will be of Type Xacute.

    Cheers,

    Jai.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.