Home
Fun with dates
Here I'm just listing some fun with dates, either from single row sql expressions or cool little queries.
APEX simple cookie example
This is an example for the use of a simple cookie which gets created after submit when click on a button. Afterwars a region inside my page shouldn't be shown anymore. The cookie itself is valid for 30 days and will save the value "1".
Find in all ALL_VIEWS
Quite some time ago when I first started blogging I wrote a post regarding limitations on searching the ALL_VIEWS dictionary view.
Simply put, if you would like to run a query such as this to find those views that contain the text "booking_no", you're not going to get very far
Create a custom download link
The default method of downloading an Interactive Report is clicking on the Action button, then the Download button and then selecting the desired format.
For the CSV report download format:
Command line backups in Apex
One thing developers like to do is keep local backup copies of their development work. Sometimes they'll copy files and suffix them with .bak or they'll store them in a version control repository. With APEX you don't copy a file to back it up. Either you have to copy the application (within the workspace) or export the application and save it locally. For one-off backups this can be ok, but as you develop with more and more applications in larger environments it can be tedious work and will slow down your development time.
More Articles...
- Redirect to specific page after login Apex Workspace
- Oracle APEX column with %
- Outlook and Apex
- Changes in sending email
- Weekday Numbers in Apex sensitive to Application Primary Language
- Blogging Platform,.. Free
- Jasper Reports Documentation
- Saving Master Before Viewing Detail
- APEX interactive report aggregate cell font color
- APEX Best Practices
