select multiple column for calender in oracle application express

3
votes

I'm trying to display multiple column data from database in one column in calender oracle application express

my SQL query is like this

SELECT EXPDATE, 'Exp: ' || SUM(EXPAMT) || ' App: ' || SUM(EXPAPPRAMT)
FROM EXPITEM
group by EXPDATE;

when I'm trying to execute it in SQL developer, there is no problem with that query

but when I'm trying to execute in oracle application express, there is an error

ORA-06502: PL/SQL: numeric or value error: dbms_sql.describe_columns overflow, col_name_len=44. Use describe_columns2

anyone know what is wrong with the query in oracle application express?

1
sqldatabaseoracleoracle-apex
Can you sum the columns with out concatenating ? – Ashutosh Arya

1 Answers

2
votes

Try to use aliases for your query fields

SELECT EXPDATE as field1, 
       'Exp: ' || SUM(EXPAMT) || ' App: ' || SUM(EXPAPPRAMT) as field2
FROM EXPITEM
group by EXPDATE;