Generierung von Bitlisten mit Hilfe von SQL am Beispiel einer Datum zu Monat Konvertierung
Ich hatte vor kurzem die Aufgabe erhalten eine Bitliste auf Basis eines Monats zu generieren. Bedeutet, ich habe einen String mit 31 Zeichen der je Zeichen...
Posts by Tag
- SQL 7
- SQL Developer 3
- Interactive Grid 3
- APEX Issues 2
- Development Tools 2
- Universal Theme 2
- Interactive Report 2
- Tools 1
- XML 1
- APEX Collection 1
- APEX 5 1
- Dynamic Actions 1
- Tooltip 1
- Debug 1
- Dynamic Action 1
- APEX Plugin 1
- Environment 1
SQL
SQL Developer: Quick Outline with SQL statements
Most of you probably know the “Quick Outline” function you have inside the SQL Developer. It helps you to easily jump between different functions/procedures ...
Using dynamic tooltips in your Interactive Report
Inside an Interactive Report (IR) I had a comment column. The comments in this column could become really large and the users wanted the comments to be autom...
Show all views including a specific string in the source code
Seems to be a simple problem and easy to fix. Actually it is not because if you try one of these examples then you will fail: 1 2 3 4 5 6 7 SELECT view_name...
Importing XML file with invalid character 22 (U+0016)
I have to import a set of XML files from time to time. Most of those XML files can be imported with out any problems. But at least one file includes a specia...
SQL: Calculate the past time between two dates in percent
Just a simple example how easy APEX can handle this kind of problem. Example: We have today the 06.11.2015 (11-06-2015) and we have two date values 01.11.2...
Oracle SQL: Calculate the amount of workdays (Mon-Fri) between two dates
I searched the net for a problem in finding a way to calculate the workdays between two date values. After I tested a couple of solutions I focused to one wh...
SQL Developer
SQL Developer: Quick Outline with SQL statements
Most of you probably know the “Quick Outline” function you have inside the SQL Developer. It helps you to easily jump between different functions/procedures ...
CREATE an APEX_COLLECTION and SELECT the data via SQL Developer
Maybe this an old hat but a lot of people don’t know how to use and analyze APEX_COLLECTION properly. For myself it is a good reminder and saves me about 2...
APEX Anwendungen importieren und exportieren mit Hilfe des SQL Developers
Wussten Sie das der Oracle SQL Developer eine sehr gute APEX Integration bietet? Ich möchte dies Anhand der Import und Export Fähigkeit näher demonstrieren. ...
Interactive Grid
Interactive Grid Automatic Position Number
If you want an automatic generating increasing number column in your interactive grid, follow these instrunctions
Interactive Grid: After Update Trigger
If you want to run a process after the “Interactive Grid” successfully updated all rows you can achieve this with a dynamic action. This can be necessary if ...
Interactive Grid: Validation – Check for duplicated column entries over all rows
I had this situation now a few times and was always to lazy to write it down. :/
APEX Issues
Check inside your APEX application if debug mode is enabled
Sounds like a simple task but whenever I have the requirement to add a region and make it conditional to check if APEX is running in debug mode. I always s...
APEX Anwendungen importieren und exportieren mit Hilfe des SQL Developers
Wussten Sie das der Oracle SQL Developer eine sehr gute APEX Integration bietet? Ich möchte dies Anhand der Import und Export Fähigkeit näher demonstrieren. ...
Development Tools
Importing XML file with invalid character 22 (U+0016)
I have to import a set of XML files from time to time. Most of those XML files can be imported with out any problems. But at least one file includes a specia...
APEX Anwendungen importieren und exportieren mit Hilfe des SQL Developers
Wussten Sie das der Oracle SQL Developer eine sehr gute APEX Integration bietet? Ich möchte dies Anhand der Import und Export Fähigkeit näher demonstrieren. ...
Universal Theme
Set APEX application name for Dev, Test and Prod environment in the same database
In case you have a small application where development, test and maybe also production environment are on the same database and your applications in this env...
Using dynamic tooltips in your Interactive Report
Inside an Interactive Report (IR) I had a comment column. The comments in this column could become really large and the users wanted the comments to be autom...
Interactive Report
Interactive Report - Column background color
One of my customers needed an IR where half of the report columns should be visualized in another color. It is really easy to integrate. Go into the repor...
APEX Master (Interactive Report) - Detail (Modal Dialog) Form: Conditional Column Link
Since APEX 5 it is much easier to create master-detail pages with modal dialogs. But there is still no declarative way to create a conditional row based col...
Tools
Importing XML file with invalid character 22 (U+0016)
I have to import a set of XML files from time to time. Most of those XML files can be imported with out any problems. But at least one file includes a specia...
XML
Importing XML file with invalid character 22 (U+0016)
I have to import a set of XML files from time to time. Most of those XML files can be imported with out any problems. But at least one file includes a specia...
APEX Collection
CREATE an APEX_COLLECTION and SELECT the data via SQL Developer
Maybe this an old hat but a lot of people don’t know how to use and analyze APEX_COLLECTION properly. For myself it is a good reminder and saves me about 2...
APEX 5
Using dynamic tooltips in your Interactive Report
Inside an Interactive Report (IR) I had a comment column. The comments in this column could become really large and the users wanted the comments to be autom...
Dynamic Actions
Using dynamic tooltips in your Interactive Report
Inside an Interactive Report (IR) I had a comment column. The comments in this column could become really large and the users wanted the comments to be autom...
Tooltip
Using dynamic tooltips in your Interactive Report
Inside an Interactive Report (IR) I had a comment column. The comments in this column could become really large and the users wanted the comments to be autom...
Debug
Check inside your APEX application if debug mode is enabled
Sounds like a simple task but whenever I have the requirement to add a region and make it conditional to check if APEX is running in debug mode. I always s...
Dynamic Action
Enable save button on form change
Today I had the requirement that the save button should stay disabled until a form item changed. After digging around I found a quite easy solution which ...
APEX Plugin
Copy and Paste to clipboard
1 Well I had the requirement to copy the content of a textarea into the clipboard. There are two ways to do that: Build a dynamic action with custo...
Environment
Set APEX application name for Dev, Test and Prod environment in the same database
In case you have a small application where development, test and maybe also production environment are on the same database and your applications in this env...