5 Replies Latest reply on Feb 23, 2016 4:39 PM by Audun V. Nes

Can SQLcl with sqlformat html support ENTMAP OFF similar functionality ?

Audun V. Nes Feb 23, 2016 11:14 AM

When generating HTML output in SQL*Plus you can use "SET MARKUP HTML ON SPOOL ON ENTMAP OFF" to ensure HTML hyperlinks are created as hyperlinks, and not text enclosed in < and >

I have tried to find a similar "ENTMAP OFF" feature in sqlcl, but without any luck. Is there such a feature ?

1. Re: Can SQLcl with sqlformat html support ENTMAP OFF similar functionality ?

thatJeffSmith-Oracle Feb 23, 2016 4:03 PM (in response to Audun V. Nes)

we're not supporting the MARKUP property, instead we have
SET SQLFORMAT html or write up the SQL to generate the HTML code as you'd prefer.
Like Show 0 Likes(0)

Actions
2. Re: Can SQLcl with sqlformat html support ENTMAP OFF similar functionality ?

thatJeffSmith-Oracle Feb 23, 2016 4:18 PM (in response to thatJeffSmith-Oracle)

sqlformat html will put your data in a HTML table, and will escape the chars so you can see the raw text

with sqlformat set to HTML up top and below just a raw SELECT spooled to an HTML file
Like Show 0 Likes(0)

Actions
3. Re: Can SQLcl with sqlformat html support ENTMAP OFF similar functionality ?

Audun V. Nes Feb 23, 2016 4:35 PM (in response to thatJeffSmith-Oracle)

HI Jeff

Thanks for replying. I am not sure I was able to phrase ny question correctly, so I will try to explain it by example.

In sqlcl I could for instance run the following query:

set sqlformat html

SELECT '<a HREF="http://servername:port/'||file_name||'">'||file_name||'</a>' FROM mytable;

WHich would not return a html table of links as the <> symbols would be escaped to < and >

is it possible to prevent that Ib sqlcl ?
Like Show 0 Likes(0)

Actions
4. Re: Can SQLcl with sqlformat html support ENTMAP OFF similar functionality ?

thatJeffSmith-Oracle Feb 23, 2016 4:29 PM (in response to Audun V. Nes)

the HTML format is to get a html table of the data, as is - so the trick would be NOT to use the HTML format at all
Like Show 0 Likes(0)

Actions
5. Re: Can SQLcl with sqlformat html support ENTMAP OFF similar functionality ?

Audun V. Nes Feb 23, 2016 4:39 PM (in response to thatJeffSmith-Oracle)

Thanks for clarifying that.
Like Show 0 Likes(0)

Actions

Go to original post