Posts

Create Application using Excel/CSV/XML files in Oracle APEX

Image
In this post, I'll walk you through the process of converting your CSV File data into application within Oracle APEX. You can find a sample CSV file here : Sample CSV File   For a walkthrough of the steps involved, refer to the following yt video tutorial -   Oracle APEX Application Creation Tutorial Key Points: 1)       Your data inside the file gets inserted into a table within Oracle APEX/Any Database you have linked. Additionally, you have the flexibility to either create a new table or update existing data within a table. 2)       APEX allows you to set the data types of each column according to your specific requirements, ensuring optimal data handling. 3)       Interactive Report, Search Report and Dashboards are automatically created within the application.    

Lets start from basics!! Create and customize application in Oracle APEX

Image
Let's embark on our journey to Oracle Apex application development! Firstly, we dive into the creation process of an APEX application. If you're new to this or need a refresher, check out the YouTube tutorial on my channel that walks you through the steps: Creating a New APEX Application Let's add some flair and customization! Here are a few tutorials to get you started: 1)    Customizing Application Name and Logo -  Want to personalize your application's identity? Learn how to change the application name and logo with this guide: Changing Application Name and Logo 2)  Enhancing Navigation Menu Style -   Navigation menus play a crucial role in user experience. Apex provides various options for Navigation menu. Changing Navigation Menu Styles 3)  Changing Application Themes and Global Notifications -   Change the look of your application by altering its theme to match with your organizations theme and logo.  Adding global noti...