<source lang="sql"> breaks with # in the query and output is not nicely formatted
Closed, DeclinedPublic
Actions

Assigned To

None

Authored By

	• bzimport
	Aug 22 2014, 7:20 AM

Description

Author: dick.pluim

Description:
Output shown when using the above source-block

Have the following block:

<source lang="sql">
SQL> create restore point RP_28052014_1356 guarantee flashback database;

Restore point created.

SQL>
set linesize 200
col time format a32
col name format a30
col scn format 99999999999999
col storage_size format 99999999999999

SELECT NAME, SCN, TIME, DATABASE_INCARNATION#,GUARANTEE_FLASHBACK_DATABASE,STORAGE_SIZE FROM V$RESTORE_POINT;

NAME SCN TIME DATABASE_INCARNATION# GUA STORAGE_SIZE

RP_28052014_1356 717168 20-06-12 09:17:21,000000000 1 YES 4294967296
</source>

This is formatted as can be shown in the attachment.

I also tried the syntaxhighlight_geshi-extension and this gives the same result.

Version: 1.23.2
Severity: minor
OS: Linux

Attached:

• bzimport raised the priority of this task from to Lowest.Nov 22 2014, 3:34 AM

• bzimport set Reference to bz69888.

• bzimport added a subscriber: Unknown Object (MLST).

The highlighter is for formatting SQL syntax only, not an interactive SQL command prompt. Such a request could be made upstream.