Hey, Dev!
Are you looking for a forum full of active developers to help you?
So if you want to:
➡️ Get answers for your development issues
➡️ Help others
➡️ Write an article
➡️ Get rewarded for your active participation
Then this place is just for you and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
ORA-01034 ORACLE not available
Vinish
It seems your Oracle database instance is not running. You need to shut down Oracle database and then restart it. The following are the steps: Run SQLPLUS: sqlplus / as sysdba Then execute the below command: shutdown immediate Then exit: exit Again open SQLPLUS: sqlplus / as sysdba Execute the folloRead more
It seems your Oracle database instance is not running. You need to shut down Oracle database and then restart it. The following are the steps:
Run SQLPLUS:
Then execute the below command:
Then exit:
Again open SQLPLUS:
Execute the following command:
See lessHOW TO CONVERT STRINGS TO DATE
Vinish
You need to turn off Escape Special Characters setting for the dynamic action you created for the date. Then it will be fine.
You need to turn off Escape Special Characters setting for the dynamic action you created for the date. Then it will be fine.
See lessHOW TO CONVERT STRINGS TO DATE
Vinish
For the Oracle Apex date item, you need to convert it to date with the date format. I am assuming that you are already displaying the date in the mm/dd/yyyy (05/25/2021) format. Below is the example: declare m_date date; duration number; begin duration := 91; SELECT to_date(:P35_DATE_OF_INVESTMENT,Read more
For the Oracle Apex date item, you need to convert it to date with the date format. I am assuming that you are already displaying the date in the mm/dd/yyyy (05/25/2021) format. Below is the example:
How to Generate Multi-Sheet Excel Export From Oracle APEX with Bi-Publisher
Vinish
I have suggested you to install BI publisher to get the add-on for MS Word installed on your computer so that you can create RTF reports. There is no need for MS Word on the server. Also, there is no need for a BI publisher on your local computer because it is already installed on a server or cloud.Read more
I have suggested you to install BI publisher to get the add-on for MS Word installed on your computer so that you can create RTF reports. There is no need for MS Word on the server.
Also, there is no need for a BI publisher on your local computer because it is already installed on a server or cloud. But you will have to install it on your local computer to get the add-on.
After creating RTF files, you would upload them in Apex > Shared Components > Report layout.
See lessHow to use GTT in Oracle Apex?
Vinish
You can use the Global temporary table in Oracle Apex as you were using in your old system. But between pages, if you experience issues because internal sessions got changed in Apex, you can use the normal table with two more columns to handle Apex user-wise. Below is an example: Add two more columnRead more
You can use the Global temporary table in Oracle Apex as you were using in your old system. But between pages, if you experience issues because internal sessions got changed in Apex, you can use the normal table with two more columns to handle Apex user-wise. Below is an example:
Add two more columns apex_user and apex_session, to your normal table. Write a process on the login page (9999) to delete the current user's data. Now, whenever you insert or update, you will update the apex_user and the apex_session with your Oracle Apex session-id (:app_session). And use these criteria to read and write the data in the whole application.
See lessSubquery in PL/SQL function which returns error text
Vinish
You can create a function to check if the supplied customer number exists or not. Below is an example: Create or Replace function check_customer(p_customer in number) Return varchar2 is cursor c_cust is select 1 from target_table where customer_id = p_customer; n_exists number; Begin open c_cust; feRead more
You can create a function to check if the supplied customer number exists or not. Below is an example:
Now you can use the above function as follows:
In SQL query:
How to add CSS to navigation bar item in Oracle Apex
Vinish
You will have to inspect the element containing the value. In my case, I found the below CSS classes, and it worked for me. Follow these steps: Create a CSS file name it notification.css and paste the following CSS in it: a.t-Button--navBar .t-Button-label { background-color: red; padding-left: 5px;Read more
You will have to inspect the element containing the value. In my case, I found the below CSS classes, and it worked for me. Follow these steps:
Create a CSS file name it notification.css and paste the following CSS in it:
Save the CSS file and close.
In Oracle Apex, click on the Shared components > Application Static Files and upload this notification.css file. After uploading, it will show you the record. Copy the text from the reference column; it should be something like #APP_IMAGES#notification.css.
Now click on the Shared Components > User Interface Attributes > Cascading Stylesheets, and in the File URLs field, paste the #APP_IMAGES#notification.css in the next line.
Click on the Apply button and test your application.
See lessHow to validate Cell Value in interactive Grid Oracle APEX?
Vinish
You can create a validation on that IG column. Select the validation type as SQL query returning rows and then add the following query in it: Example Select 1 from dual where :order_value between :p1_min and :p1_max;
You can create a validation on that IG column. Select the validation type as SQL query returning rows and then add the following query in it:
Example
See lessAPEX 19 or 20, how do I add background color or text color to each tab within the tab container?
Vinish
To change the background of each tab, go to the Advanced > Customer Attributes and paste the following code: style="background-color: orange;" Change the color according to your needs. To change the foreground color of each tab. Assign a static id to each tab, then adds the following CSS in the pRead more
To change the background of each tab, go to the Advanced > Customer Attributes and paste the following code:
Change the color according to your needs.
To change the foreground color of each tab. Assign a static id to each tab, then adds the following CSS in the page's CSS > inline section. For example, you have assigned the static id as tab1 then the CSS code will be as follows:
Add #SR_ to your static ids to apply foreground color in the CSS.
See lessHow to Generate Multi-Sheet Excel Export From Oracle APEX with Bi-Publisher
Vinish
The following are my answers: Yes, you have to create an RTF file in MS Word. Also, install the latest BI publisher version on your Windows, then from the BI publisher windows menu, you will get an option Add-on/Plugin for MS Word. Click on this option to install. After that, open the MS Word, and tRead more
The following are my answers:
I will soon write a tutorial on it and then will share it with you.
See less