 |
|
Oracle on the Internet
Oracle Tips by Burleson Consulting
|
Question: How can I
access my Oracle database over the Internet?
Answer: As the
world's most powerful database, Oracle has many ways to
web-enable an Oracle database, most notably the free Oracle XE
combined with Apex.
You can internet-enable Oracle
with any of these technologies:
-
Oracle PHP
- A fast and easy way to interface Oracle on the Internet
-
XMLDB
- A great way to quickly generate web pages with Oracle content
-
Apex
(Formerly HTML-DB) - Oracle
Application Express is an easy way to make Oracle interact with the
internet.
-
Java tools - JDeveloper, J2EE and Oracle JDBC
Oracle has graciously provided the
license-free Oracle XE database, which has APEX and makes the
ideal environment for web-enabling Oracle data (Note that Oracle
XE has limits, and you must have a database < 4 gig and only run
one CPU).
Many companies are taking baby steps into the internet by
deploying customer information periodically, leaving the remote
Oracle database (the one that's connected to the Internet),
read-only except when it's being refreshed.