Posts

Showing posts from June, 2017

Work with Syntax Highlight

Image
I'd like to share my work with syntax highlight in APEX. Demo Please check demo from  apex.oracle.com . Sorry that currently there is no source code shared. But if you check the demo, there are detailed steps about how to integrate these libs. Review  Here is my rough review for these highlight libs, just in my opinion and based on my work with them in APEX. Welcome for any advises or comments. There are four JS libs integrated, and reviewed. Click the link below to check the corresponding demo page. CodeMirror SyntaxHighlighter PrismJS highlight.js Have a quick check from the pic below. CodeMirror SyntaxHighlighter PrismJS highlight.js Special Thanks to Markdown APEX Plugin  The tool makes my demo more like a wiki or blog post for text content. (If you had ever used powerful markdown in specific application, like Atlassian Confluence, you would definitely prefer to use them for text-like knowledge sharing rather than r

Recover a deleted APEX page or application - from Nick Buytaert

Today, Nick Buytaert's post saved my life.  I deleted an app incautiously when I was talking via cellphone and planed to save the app definition. https://apexplained.wordpress.com/2012/07/12/recover-a-deleted-apex-page-or-application Thanks Nick. Thanks for APEX with the fantastic Oracle flashback feature. Lessons learnt: never touch you App when you are on the phone... Update 20160622: I just had a interested thought, is that possible to recover the application created by other uses which just have been deleted???

Use Plugin Code Editor - Part 4/4: Retrospect

I this post, I will retrospect my work on this and share lessons learnt. Please click TOC link on right side to jump to specific section or See more Use Plugin Code Editor - Part 1/4: Demo Use Plugin Code Editor - Part 2/4: Intro Use Plugin Code Editor - Part 3/4: Custom Use Plugin Code Editor - Part 4/4: Retrospect Know Issues button title, there are 7 js errors  for each plugin in console when rendering native page, Code Editor in native demo page sometimes occupies the whole page width sql syntax check, in the pages using item binding syntax validation, can not return detailed error info like ORA-xxx message, in the pages using item binding syntax validation, can just go to inline with field or in notification area. Query Builder, can be enabled but does not work Testing No tests no bugs. If you find, please feel free to leave your comments here or in github repo . Technical Support Now Oracle APEX provides official release for these two plugins with APEX it

Use Plugin Code Editor - Part 3/4: Custom

If you are visiting this page, I suppose you have been encountering these issues I mentioned in my previous post. I am joking. May be or may be not. That's OK. In this post, I will go through these issues case by case,  illustrate what I did to fix or provide a workaround and then explain how I customize Native, Hybrid and Editor to Textarea demo pages. Click the link in TOC  to jump to the section you are interested in or See more: Use Plugin Code Editor - Part 1/4: Demo Use Plugin Code Editor - Part 2/4: Intro Use Plugin Code Editor - Part 3/4: Custom Use Plugin Code Editor - Part 4/4: Retrospect Fix Issues Button Title If you use Code Editor plugin directly, you will get lots of errors  logged in console as below for button title/name translation. And from page, you will find these button title letters are upper case. Format(CODE_EDITOR.SHORTCUT_TITLE): too many arguments. Expecting 0, got 2 In order to fix this issue or provide a workaround, I had to u

Use Plugin Code Editor - Part 2/4: Intro

I suppose you have viewed demo page and start to import one plugin in your own application.  And you might want to know more about how to use these two plugins and go further to the detail. Then this post is going to introduce the basic interfaces for Code Editor plugin, including both item and region types. Click the link in TOC  to jump to the section you are interested in or See more: Use Plugin Code Editor - Part 1/4: Demo Use Plugin Code Editor - Part 2/4: Intro Use Plugin Code Editor - Part 3/4: Custom Use Plugin Code Editor - Part 4/4: Retrospect What's Code Editor? Code Editor is the plugin for Oracle APEX internal applications that wraps CodeMirror, enables SQL and PL/SQL syntax validation, integrates to APEX item component and provides region type variation named CLOB Code Editor. See Also: APEX-5.1 Doc: 7.3 Understanding Page Designer UI Elements If you check the annotation in file widget.codeEditor.js, you will find: /*! codeEditor - a jQuery UI

Use Plugin Code Editor - Part 1/4: Demo

Image
If you want to use Code Editor plugin in Oracle APEX internal applications, you need 6 steps below to make it happen from scratch. get an application with f4000 theme (see  Use Theme: APEX 5.0 ) import f4000 to your APEX and export plugin "Code Editor" create test pages using Code Editor detect and add missed CSS and JavaScript files grant corresponding privilege to application parsing schema check issues and fix rock and roll Note: Here using internal Theme APEX5.0 is not mandatory but it's helpful from scratch. Now, you could jump over these steps,  import my demo applications and start you work with Code Editor. Demo If you find page loading without GIFs, please click HD GIFs link below (Due to the GIF size, it will take a while to load.): Native Hybrid Migrated Native Main features: theme APEX 5.0 supported all item type Code Editor plugins with 9 supported code modes with 11 items based on supported modes (PL/SQL Expression and Fun