Skip to Main Content

APEX

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 show sql result as html in text-area type item in apex

Sadath.SaadApr 3 2016 — edited Apr 4 2016

Hi all,

As we know this query in command prompt will give an html result

SET ECHO OFF

SET MARKUP HTML ON SPOOL ON

SPOOL emp1.html

SELECT * FROM emp where deptno=10;

SPOOL OFF

SET MARKUP HTML OFF

SET ECHO ON

In this same way onpage load i want this result in one of my page item (type:text-area)..

Is this possible???

Or else this query will execute then it is better

select /*html*/ * from emp;

Regards

Saad

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 2 2016
Added on Apr 3 2016
6 comments
2,214 views