Markdown Column support in Classic report in Oracle APEX 20.1

MarkDown Column support in Classic report in Oracle APEX 20.1

As we have been using Markdown editor item from APEX 19.2. It’s embedded with great features . Now we have the markdown Editor item compatible with classic reports in APEX 20.1.

Let’s have a walk through-

We need to create a Classic report with markdown column.

Headers

Syntax:

# This is an <h1> tag
## This is an <h2> tag
###### This is an <h6> tag

Query:

Copy Code

 SELECT
       '
# This is an h1 tag
## This is an h2 tag
###### This is an h6 tag' markdown
  FROM DUAL

Preview

Emphasis

Syntax:

*This text will be italic*
_This will also be italic_
**This text will be bold**
__This will also be bold__
_You **can** combine them_

Query:

Copy Code

SELECT
       '*This text will be italic*</br>
        _This will also be italic_</br>
        **This text will be bold**</br>
        __This will also be bold__</br>
        _You **can** combine them_' markdown
  FROM DUAL

Unordered List

Syntax:

* Item 1
* Item 2
  * Item 2a
  * Item 2b

Query:

SELECT
       '* Item 1
* Item 2
  * Item 2a
  * Item 2b' markdown
  FROM DUAL

Preview

Ordered List

Syntax:

1. Item 1
1. Item 2
1. Item 3
   1. Item 3a
   1. Item 3b

Query:

SELECT
       '1. Item 1
1. Item 2
1. Item 3
   1. Item 3a
   1. Item 3b' markdown
  FROM DUAL

Preview

Images

Syntax:

![Blog Logo](https://1.bp.blogspot.com/small.png)</br>
        Format: ![Alt Text](url)

Query:

SELECT
       '
![Blog Logo]
(https://1.bp.blogspot.com/-o7OPlwezDbI/Xl6giMUQSZI/AAAAAAAAdcQ/0k-lFF7lmtYYf0pWjKx7eOc8YPGpmj3CQCK4BGAYYCw/s1600/small.png)
         Format: ![Alt Text](url)'
          markdown
  FROM DUAL

Preview Preview

Links

Syntax:

https://www.ashishsahay.com - automatic!
[Ontoor Solutions](https://www.ashishsahay.com)

Query:

Copy Code

SELECT
       'https://www.ashishsahay.com - automatic!</br>
[Ontoor Solutions](https://www.ashishsahay.com)'
          markdown
  FROM DUAL

Preview

Blockquotes

Syntax:

As Kanye West said:
> We're living the future so
> the present is our past.

Query:

Copy Code

SELECT
       '> We''re living the future so
> the present is our past.'
          markdown
  FROM DUAL

Preview

Syntax highlighting

Syntax:

Copy Code

function fancyAlert(arg) {
  if(arg) {
    $.facebox({div:'#foo'})
  }
}

Query:

Copy Code

SELECT
       '```javascript
function fancyAlert(arg) {
  if(arg) {
    $.facebox({div:''#foo''})
  }
}
```' markdown
  FROM DUAL

Preview

Task Lists

Syntax:

- [x] @mentions, #refs, [links](), **formatting**, and <del>tags</del> supported
- [x] list syntax required (any unordered or ordered list supported)
- [x] this is a complete item
- [ ] this is an incomplete item

Query:

Copy Code

SELECT
       '- [x] @mentions, #refs, [links](), **formatting**, and <del>tags</del> supported
- [x] list syntax required (any unordered or ordered list supported)
- [x] this is a complete item
- [ ] this is an incomplete item'
          markdown
  FROM DUAL

Preview

Tables

Syntax:

First Header | Second Header
------------ | -------------
Content from cell 1 | Content from cell 2
Content in the first column | Content in the second column

Query:

Copy Code

SELECT
       ' First Header | Second Header
------------ | -------------
Content from cell 1 | Content from cell 2
Content in the first column | Content in the second column'
          markdown
  FROM DUAL

Preview