LogoOntoor Blogs
  • Archives
  • Categories
  • Tags
  • APEX Plugins
  • Links
    • APEX Tutorials
    • Ontoor Plugins
    • Web Tutorials
  • Menu
    • APEX
    • APEX Ajax
    • APEX JavaScript
    • Interactive Grid
    • Oracle
    • Plugins
    • SQL
  • Videos
    • APEX hours
    • Ontoor Concepts
    • Ontoor Extras
    • Ontoor Shorts
  • Settings
  • Settings
  1. Home
  2. Author
  3. Vikas Pandey

How to Set Custom Login background in Oracle APEX

Avatar Vikas Pandey Apr 3, 2020 1 min read Vikas PandeyAPEXAPEXPLSQLSQL
How Set Custom Login background in Oracle APEX Oracle APEX 20.1 has given default solution for changing only background colour but sometimes user want to set his custom picture on that case this post will help you to set custom login background Image. Step 1. Upload your static image. Solution: Copy and paste …

How to Create Dynamic Navigation Menu in Oracle APEX

Avatar Vikas Pandey Apr 1, 2020 1 min read Vikas PandeyAPEXAPEXPLSQLSQL
How to Create Dynamic Navigation Menu in Oracle APEX Sometimes user don’t want to go with a default navigation menu then on those cases will go ahead with a dynamic navigation menu so today I will let you know how you can create a dynamic navigation menu. Create a table with following this SQL script: CREATE …

How to Create Dynamic Navigation Menu in Oracle APEX

Avatar Vikas Pandey Apr 1, 2020 1 min read Vikas PandeyAPEXAPEXPLSQLSQL
How to Create Dynamic Navigation Menu in Oracle APEX Sometimes user don’t want to go with a default navigation menu then on those cases will go ahead with a dynamic navigation menu so today I will let you know how you can create a dynamic navigation menu. Create a table with following this SQL script: CREATE …

How to Add Vertical/Horizontal Scroll Bar in Classic Report Oracle APEX

Avatar Vikas Pandey Apr 1, 2020 1 min read Vikas PandeyAPEXAPEXPLSQLSQLClassic Report
How to Add Vertical/Horizontal Scroll Bar in Classic Report Oracle APEX Today I will tell you how to add scroll bar vertical and horizontal in a classic report. I have created a classic Report with the following SQL Query: select EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO, END_DATE, DESCRIPTION, CITY, …

Auto New Line Generation in Interactive Grid Oracle APEX

Avatar Vikas Pandey Mar 31, 2020 1 min read Vikas PandeyAPEXAPEXPLSQLSQLPLUGINSTEMPLATES
Auto New Line Generation in Interactive Grid Oracle APEX Sometimes user don’t want to go with add row button for a new row generation on those cases I will show you how to generate new line without using add row button. for this, you will have to follow some simple steps: Create Interactive grid using following …

3 Ways to Refresh Oracle APEX Page Automatically Every 3 Second

Avatar Vikas Pandey Mar 30, 2020 1 min read Vikas PandeyAPEXAPEXPLSQLSQL
3 Ways to Refresh Oracle APEX Page Automatically Every 3 Second In some cases, we need to refresh our page within time or second so I will show you 3 ways to refresh your oracle apex page within a specific time. First Solution: Copy and paste following HTML code to your page in HTML header Section. <meta …

Print Preview Region into PDF Plugin in Oracle APEX

Avatar Vikas Pandey Mar 29, 2020 1 min read Vikas PandeyPLUGINSDynamic ActionAPEXPLSQLSQLPLUGINSDynamic ActionOntoorPlugins
Print Preview Region into PDF Plugin in Oracle APEX This plugin is updated version 2.0 of old plugin v1.0 which converts your APEX region data or report data into pdf format. Now the change is it will also support open print preview and APEX chart instead of download. For better understanding please look at the …

Writing File to Oracle Directory

Avatar Vikas Pandey Mar 27, 2020 2 min read Vikas PandeyORACLEUTL_FILEORACLEPLSQLSQL
How to write file to ORACLE Directory using PL/SQL? Creating directory GRANT CREATE ANY DIRECTORY TO apex_19_2; CREATE OR REPLACE DIRECTORY my_dir AS 'C:\App\MY_DIR'; Writing File To Directory DECLARE l_file UTL_FILE.file_type; BEGIN l_file := UTL_FILE.fopen ('MY_DIR', 'First_File.txt', …

3 Ways to Select all checkbox In Classic or Interactive Report Oracle APEX

Avatar Vikas Pandey Mar 27, 2020 2 min read Vikas PandeyAPEXAPEXPLSQLSQLInteractive Report
3 Ways to Select all checkbox In Classic or Interactive Report Oracle APEX I have received a few emails regarding how to implement Select All checkbox in the column header. This functionality work if the user wants to process particular data as per his requirement. I will show you there is a three-way to select All …

Render Region to Navigation Menu Oracle APEX

Avatar Vikas Pandey Mar 26, 2020 1 min read Vikas PandeyPLUGINSDynamic ActionAPEXPLSQLSQLPLUGINSDynamic ActionOntoorPlugins
Render Apex Region to Navigation Menu in Oracle APEX version 1.0 This Plugin will render or move the apex region to the navigation menu, for that first create a region then create dynamic action on page load and Choose that region on the affected element. You Must have to choose region template Blank with attributes. …

Enable/Disable Editable Interactive Report Column Based on Another Column in Oracle APEX 5.0

Avatar Vikas Pandey Mar 22, 2020 2 min read Vikas PandeyAPEXAPEXPLSQLSQLJQUERY
Enable/Disable Editable Interactive Report Column Based on Another Column in Oracle APEX 5.0 In this tutorial, you will learn Enable/Disable Interactive Report Column Based on Another Column in Oracle APEX. I’ve seen in interactive grid it is possible using dynamic action. If I want to use dynamic action on …

How to Create a Duplicate Record In Interactive/Classic Report Oracle APEX

Avatar Vikas Pandey Mar 19, 2020 2 min read Vikas PandeyAPEXAPEXPLSQLSQLClassic Report
How to Create a Duplicate Record In Interactive/Classic Report Oracle APEX Here is Small Tip How to Create a Duplicate Record In Interactive/Classic Report Oracle APEX. For that first wee need to create a Apex Collection which will be fire on page Load. DECLARE v_collection_name VARCHAR2 (30) := 'DUPLICATE'; …

Export Oracle APEX Application automatically on Daily Basis

Avatar Vikas Pandey Mar 18, 2020 3 min read Vikas PandeyAPEXAPEXPLSQLSQL
How to Export Oracle APEX Application automatically on Daily Basis Today i got the solution to export apex application automatically instead of manual way. In this tutorial, you will learn how to export Apex Application with these simple steps which i have given below. First create your Directory “APEX_TEMP …

Export Oracle APEX Application automatically on Daily Basis

Avatar Vikas Pandey Mar 18, 2020 3 min read Vikas PandeyAPEXAPEXPLSQLSQL
How to Export Oracle APEX Application automatically on Daily Basis Today i got the solution to export apex application automatically instead of manual way. In this tutorial, you will learn how to export Apex Application with these simple steps which i have given below. First create your Directory “APEX_TEMP …

What is Page Zero / Global Page in Oracle APEX?

Avatar Vikas Pandey Mar 16, 2020 2 min read Vikas PandeyAPEXAPEXPage Zero
What is Page Zero / Global Page Oracle APEX? The global page is a feature incorporated in Oracle Application Express and functions as a master page in your application. You can define a separate Global Page, Login Page, and Home Page for each user interface. A Global Page is a special page. Unlike all other pages it …
  • ««
  • «
  • 1
  • 2
  • 3
  • 4
  • 5
  • »
  • »»
Ontoor
India
About
Ads to keep this blog alive.

Featured Posts

  • Ajax Callback application process and it's usage In Oracle APEX
  • How to create application process and it's usage In Oracle APEX
  • APEX Font Toggler (AFT)
  • LocalStorage and SessionStorage in JavaScript
  • Dialog Page drawer in Oracle APEX

Recent Posts

  • Interactive Grid intrdoduction| Ontoor Concepts #1
  • Oracle APEX Dynamic Navigation Menu : Ontoor Extras
  • APEX Friendly URL | Ontoor Shorts #7
  • Application Process | Ontoor Shorts #6
  • Ajax Callback application process and it's usage In Oracle APEX
  • How to create application process and it's usage In Oracle APEX
  • APEX_DATA_PARSER performance issues and DBMS_LOB
  • APEX Font Toggler (AFT)
  • LocalStorage and SessionStorage in JavaScript
  • Dialog Page drawer in Oracle APEX
Ads to keep this blog alive.

Article publishers

Ashish Sahay 139 Vikas Pandey 71 Ontoor Team 3 Anuj Kumar 2

Categories

APEX 132 ORACLE 28 PLSQL 16 PLUGINS 11 javascript 9 IG 8 Shorts 7 DBA 6 GitHub 4 SQL 4 BLOGGER 3 ORDS 3 APEX_JSON 2 APEX_WEB_SERVICE 1 CSS 1

Interactive Grid Shortcodes

CALCULATION 1 Custom 1 Detail View 1 GRID CHECKBOX 1 Interactive Grid 1 Nested 1 Progress 1 Toolbar 1 Validation 1

APEX Plugins

Dynamic Action 8 Region 3

Short Codes

APEX 17 Interactive Grid 8 SQL 6 JAVASCRIPT 5 PLSQL 3 apex.confirm 1 APEX_WEB_SERVICE 1 FILE_UPLOAD 1 Oracle APEX 1

Tags

APEX 146 PLSQL 120 SQL 116 ORACLE 34 PLUGINS 25 Interactive Grid 14 TEMPLATES 14 JavaScript 13 Dynamic Action 11 OntoorPlugins 11 API 9 DBA 8 SHORTS 7 Classic Report 5 APEX_JSON 4 Universal Theme 4 APEX 21 3 APEX_21.2 3 APEX_WEB_SERVICE 3 BLOGGER 3 CSS 3 GitHub 3 Interactive Report 3 ORDS 3 PLUGIN 3 UI 3 WHAT's NEW 3 APEX+CSS 2 apex.server 2 APEX_COLLECTIONS 2 APEX_DATA_PARSER 2 APEX_DATA_PASER 2 APEX_HOURS 2 APPLICATION PROCESS 2 BOILERPLATES 2 Coalesce 2 DBMS_LOB 2 DOWNLOAD 2 GOOGLE 2 ITEM 2 JSON_TABLE 2 LOGO 2 MARKDOWN 2 Navigation 2 RDS 2 TEMPLATE 2 THEMES 2 UNESCAPE 2 WRITE_RAW 2 AGILE 1 AJAX 1 APEX 20.1 1 APEX and CSS 1 APEX COLLECTION 1 APEX_COLLEXTION 1 APEX_DATA_LOADING 1 APEX_ITEM 1 APEX_LANG 1 APEX_SESSION 1 apex_util 1 APEX_ZIP 1 ATTACHMENT 1 ATTRIBUTES 1 BLOB 1 BULK 1 Cascade 1 CHECKSUM 1 CLOB 1 COLLECTION 1 COLUMN_ORDERING 1 CONFIRM 1 CREATE_COLLECTION_FROM_QUERY_B 1 CREATE_COLLECTION_FROM_QUERY_B2 1 CUSTOM 1 Custom Validation 1 DBMS_METADATA 1 DDL 1 Deleted 1 DIALOG 1 Directory 1 DRAWERS 1 Dynamic Menu 1 DYNAMIC TOTAL 1 Editors 1 EXPLODES 1 Extras 1 FILE_BROWSE 1 FILE_UPLOAD 1 FILES 1 FORALL 1 Function 1 HTML 1 IG 1 Interactive Active 1 INVISIBLE 1 IR 1 JavaScript API 1 JoelKallmanDay 1 JQUERY 1 JS_API 1
Ads to keep this blog alive.
  • Copyright © 2021 Ontoor Solutions. All Rights Reserved.