| UI to Display DB Table to End Users & ability to Update Table from UI [message #670305] |
Mon, 25 June 2018 14:18  |
 |
nickz
Messages: 39
Registered: September 2013
Location: US
|
Member |
|
|
I am on Oracle DB 11.2.0.4. Maybe, this a very dumb question, but is there any easy/simplest way to display my table contents to the end user on a UI and have them make changes to it on the click of a button and the changes would be committed to the DB table.
REQUIREMENT:
- I have a table in DB, which has some info.
- The end users should be able to see the data in the DB table on a web page.
- The end user should be able to EDIT the data they see, and click on UPDATE button, which commits the changes to the DB table (addition of new record, updates to existing record, deletion of a record).
I haven't worked in any UI. Is there any simplest and easiest way (any WYSIWYG tool) to connect to Oracle DB and have these displayed in web form?
Example: Spotfire, where you can create a library page > add DB tables > design the page as you want > publish (which provides a web url)
.
[Updated on: Mon, 25 June 2018 14:22] Report message to a moderator |
|
|
|
|
|
|
|
| Re: UI to Display DB Table to End Users & ability to Update Table from UI [message #670311 is a reply to message #670308] |
Tue, 26 June 2018 03:27  |
gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK
|
Senior Member |
|
|
Quote:Is it available as part of the Oracle DB 11g or available as part of a separate licensing?
If your Oracle install is licensed, Apex is free.
Quote:What do I need to install n the client side to get started with it?
A web browser.
Quote:Does the DBA need to enable something to enable the seamless integration with our database?
There is a database install to create some Apex objects in the database and an image install for the application server. This can be the same machine as the database server if required.
Quote:What's the Oracle APEX version available with 11.2.0.4?
Go for Apex 5.1
[Edit: typo]
[Updated on: Tue, 26 June 2018 03:49] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
) will be happy to help. Or teach yourself, there is plenty of online training material provided by Larry.