Skip to main content

Adding Copyright information to application export files

Oracle APEX 21.2 has introduced a new feature using which we can include copyright information in the application exports. There is a new application property Copyright Banner. We can enter copyright text here. We can use substitution strings #APP_NAME# and #YEAR# in the copyright text. When writing copyright text into the export files, APEX will replace these substitution strings with respective values. #APP_NAME# will be replaced with the current application name and #YEAR# will be replaced with the current calendar year in YYYY format.

So, let's enter some dummy text into Copyright Banner for testing.

Name: #APP_NAME#
All Rights Reserved.
Copyright (c) 1999, #YEAR#, XYZ-Dummy Company.
For further details please refer

Copyright Banner Application Property

Now, if we export the application, then we can see the below copyright information at the top of the application export file as below. Observe, substitution strings are replaced with their values in the generated copyright text.

Copyright Information in the export file

If we export the application as a zip file, then there will be a text file with the name copyright.txt under the exported zip file. This file will contain copyright information. 

Sample copyright.txt file

Copyright information will also be included in Component Exports. However, when exporting components as a zip file, then copyright.txt will be included in the zip file only when Include installation files flag is enabled.

What do you think about this little feature added to APEX?

Thank you.


hi hari, No one should modify our codes or view. Is there any mechanism.
Since all codes are there in DB server. Only Developer should able to access.
Client IT also have access to DB but they should not touch Apex modification.
Please suggest any mechanism
Hari said…
Hi Mydeen,

In such cases, you can install "Oracle APEX Runtime Environment". With this users can run their applications, but they will not be able to see or modify APEX code. Check below link for more details.


Popular posts from this blog

Interactive Grid - Conditional Enable/Disable

In this blogpost, I am going to discuss few approaches using which we can conditionally enable/disable Interactive Grid (IG) column(s) based on other column(s) values. Note:    There is a bug  30801170  in APEX 19.2/20.1 with respect to "enable/disable" dynamic actions for IG columns. Workaround for this bug is provided at the end of this blogpost . This bug has been fixed in APEX version 20.2. Client Side Only Conditions If conditions to enable/disable are simple, then we can check those conditions easily on the client side. For e.g. let's consider IG on EMP table with following SQL Query. SELECT EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO FROM EMP Let's consider the requirement as - Enable "Commission" column only when JOB is equals to 'SALESMAN' and disable "Commission" column in all other cases. This can be done declaratively using dynamic actions (DA) DA "Enable/Disable Commission - 1" Create DA and give it a prope

Interactive Grid - Bulk Operation on Selected Rows

What's the Problem? Let's say you have an IG on employee table and you want to update selected employees commission based on user's input. Ideally, it should be very simple, where you can write UPDATE statement in page process and select IG region as "Editable Region" under "Execution Options" of the page process. But, when you select rows and submit page, you can see that, this process won't get executed! The reason is  Selection of 'Row Selector' check-boxes is not considered as row-change. Thus selected rows are not submitted to server. So, is there any work around?  Yes! Luckily there are lot of JavaScript (JS) APIs available to work with IG. If you are not already aware, you can refer "APEX IG Cookbook"  or  JavaScript API Reference documentation. If we continue with above Employee IG example, when user selects IG rows, enters "Commission %" and clicks on "Update Commission" button, then we can writ

Few tips on Gantt Charts

Oracle APEX offers several beautiful chart types which are based on Oracle JET Data Visualizations. Gantt Chart is one such beautiful and useful chart. However, when I have searched in Google for some help on Gantt Charts, there are not many blogs posts talking about it. So, I thought, I could write one with few basic tips which I have learned this year. I have used Gantt Chart to display employees calendar data and my targeted output was something like below. Pic-1 Looks simple, correct? However, it's little tricky to get there. Multiple Tasks Per Row: When I look at the output, first I thought, I will have to write a query which gives tasks data and employee data with 1 row per task. That is, if there are 10 tasks to be displayed, then there should be 10 rows in SQL query output. But, it's not correct. Instead, I should have 1 row for each task + 1 row for each employee (parent). So I need to write a query which will output data in below format. Pic-2 A