Data Upload and Download to Cloud Symbol
Oracle Noon (Oracle Application Express) is a web-based software evolution system that runs on an Oracle Database. It comes equally standard with all Oracle Database editions and Oracle Autonomous Database service and, naturally, is fully supported.
In other words, Oracle APEX is a low-lawmaking development platform for building scalable and secure enterprise apps that solve real bug and provide immediate value. And so, you can deploy those apps anywhere. Y'all won't need to be an proficient in a vast assortment of technologies to deliver excellent solutions.
Democratic Database Service does not crave yous to install annihilation to start using APEX. Later on you provision an Autonomous Database, the APEX platform is also installed and ready to utilise.
The electric current tutorial will explain how to create an awarding to Upload and Download files. The data is hosted in the BLOB column of the Democratic Database.
Admission Oracle Apex Platform
This tutorial assumes that y'all have already possessed some basic knowledge of Oracle Democratic Data Warehouse (ADW). You may refer to the article nearly provisioning an Oracle Autonomous Database to refresh your knowledge.
At present, you need to access the Oracle Cloud Infrastructure Console (OCI) and go to the provisioned Autonomous Database instance:
Click on Service Console – yous will get to the Service Console page where the ADMIN user of Autonomous Database can monitor the database system and execute authoritative tasks.
Navigate to Development . Oracle APEX is already installed on top of Oracle Autonomous Database:
You become to the APEX login folio .
Log in as an ADMIN user – click Sign In to Administration . The purpose is to create an Noon user. So you will use it to develop your awarding.
APEX requires you to create a workspace with a shared work area. Multiple developers can work there when edifice their applicationŃ–:
Click on Create Workspace . Yous demand to provide the Democratic Database user.
Confirm by clicking the Create Workspace button.
Create an Noon Programmer
Navigate to the Manage Workspaces menu and choose Manage Developers and Users under the Workspace Actions department:
A defended page appears. You will see the two default users in that location:
- ADMIN user is on the INTERNAL workspace
- DEMO user is on the DEMO workspace (yous created the workspace in the previous stride).
Both users are of the Workspace Administrator business relationship type.
Click Create User in the top-right corner. The Create / Edit User folio appears. Hither, you have to create a developer who volition be assigned to develop the Upload/Download application.
Use the following details:
User Attributes
- Username: dev_1
- Email: you should enter a valid electronic mail
- First Name: DEV 1
Account Privileges
- Workspace: DEMO (this workspace created)
- Default Schema: DEMO (the database user schema in Democratic Database)
- User is an administrator: No
- User is a programmer: Yes
- Go along other attributes equally default
Password (For authentication confronting workspace user account repository only)
- Countersign to utilize access Workspace
- Password: Oracle#202105 (Password must satisfy the Oracle Database password policy)
- Confirm Password: Oracle#202105
- Require Alter of Countersign on Offset Use: No (this option would require you to change the password in the commencement-fourth dimension login)
Click Create User , and you can run into the new user in the list. The account blazon of the new user is Developer .
Click on the ADMIN contour icon on the pinnacle-right corner and Sign Out .
Permit'southward try to access APEX with the new dev_1 user nosotros've merely created.
On the login folio, provide the workspace assigned to your account, enter your username and password. In this examination case, log in with dev_1 and password Oracle#202105:
You lot can run into the home folio (the Developer account type). Now yous are gear up to build your application.
Install Upload and Download Application
The Noon platform has some pre-built applications, such as plug-in. You tin re-employ them speedily.
Click on App Gallery and get the card. It offers a listing of prebuilt apps (sample apps) bachelor in APEX:
Click on Sample File Upload and Download > Install App to add this application to your workspace:
If you are authorized successfully, click Adjacent to install this app.
Click on the Run icon to execute the application.
Now, let'south attempt to upload a sample file with the installed application.
On the left panel, create a new project (e.grand., My Upload Project) by clicking on the plus icon:
Fill the mandatory fields:
The projection is created, and you can upload files. Navigate to the Home page and click on the Plus icon on the Contempo Files panel.
The Upload folio appears. Scan to the file yous want to upload and click Add File :
Annotation: The file is uploaded and stored in the BLOB column of Autonomous Database.
Let's access your Autonomous Database instance and query the data. You will see two tables created there:
- EBA_DEMO_FILES to store the data of files you uploaded
- EBA_DEMO_FILE_PROJECT to store the information of your projects
Conclusion
Oracle Noon uses the database encapsulated simple metadata-driven architecture. It provides fast data access, top operation, and scalability out of the box.
With APEX, you can develop and deploy your application anywhere with minimum programming skills. APEX too provides the prebuilt set of sample applications – you just need to install them to beginning using them.
Last modified: September 23, 2021
Source: https://codingsight.com/create-an-upload-download-application-with-oracle-apex/
0 Response to "Data Upload and Download to Cloud Symbol"
Post a Comment