|
Replies:
10
-
Pages:
1
-
Last Post:
May 17, 2007 1:08 AM
Last Post By: Jes
|
|
|
Posts:
8
Registered:
04/10/07
|
|
|
|
Application Express as front end
Posted:
May 14, 2007 7:29 PM
|
|
|
|
Can I use APEX as the front-end to the main Oracle database i.e using ODBC or OLE DB or something similiar? I need the data stored in my APEX applicaiton in the main database.
|
|
|
Posts:
4,839
Registered:
06/22/00
|
|
|
|
Re: Application Express as front end
Posted:
May 14, 2007 11:24 PM
in response to: user568777
|
|
|
|
The purpose of ApEx is to give you exactly that - a front end for your data.
Denes Kubicek
|
|
|
Posts:
8
Registered:
04/10/07
|
|
|
|
Re: Application Express as front end
Posted:
May 14, 2007 11:53 PM
in response to: Denes Kubicek
|
|
|
|
Actually what I meant was, can Oracle Database Express be used as the front-end to Oracle 10g.
|
|
|
Posts:
4,839
Registered:
06/22/00
|
|
|
|
Re: Application Express as front end
Posted:
May 15, 2007 12:04 AM
in response to: user568777
|
|
|
Sure it can. That is exactly what I stated. ApEx is a part of 10g database and is meant to
give you a possibility to report, enter, evaluate your data residing in that database. See my
demo application for some examples:
http://htmldb.oracle.com/pls/otn/f?p=31517:1
Denes Kubicek |
|
|
Posts:
402
Registered:
10/20/98
|
|
|
|
Re: Application Express as front end
Posted:
May 15, 2007 6:23 AM
in response to: Denes Kubicek
|
|
|
User,
If you meant developer 10g, then yes to that too. 
Chad |
|
|
Posts:
1,859
Registered:
04/21/07
|
|
|
|
Re: Application Express as front end
Posted:
May 15, 2007 12:57 PM
in response to: cedwards
|
|
|
This thread was spotted to be included in the weekly APEX forum wrap-up.
(in the funny part)
Thanks,
Dimitri
-- APEX Forum wrap-up --
@ http://dgielis.blogspot.com |
|
|
Posts:
1,812
Registered:
04/24/00
|
|
|
|
Re: Application Express as front end
Posted:
May 15, 2007 2:10 PM
in response to: user568777
|
|
|
Actually what I meant was, can Oracle Database Express be used as the front-end to Oracle 10g.
Maybe there is a misunderstanding. Oracle APEX isn't bound to the Oracle XE database version. You can also install it into your regular main Oracle database. Then you are able to directly access your data.
Patrick
My APEX Blog: http://inside-apex.blogspot.com
The ApexLib Framework: http://apexlib.sourceforge.net
The APEX Builder Plugin: http://sourceforge.net/projects/apexplugin/ |
|
|
Posts:
4,839
Registered:
06/22/00
|
|
|
Posts:
8
Registered:
04/10/07
|
|
|
|
Re: Application Express as front end
Posted:
May 16, 2007 7:37 PM
in response to: Denes Kubicek
|
|
|
|
Yes I thought that XE (Express) and Application Express (ApEx) were one in the same until very recently.
So I gather that XE (Express) is stand-alone and cannot access tables in Oracle 10g, where Application Express (ApEx) is a front-end tool allowing access to any database. Is this correct?
|
|
|
Posts:
420
Registered:
04/08/01
|
|
|
|
Re: Application Express as front end
Posted:
May 16, 2007 10:30 PM
in response to: user568777
|
|
|
|
XE is Oracle Database Express Edition, which is the lowest level Edition of the Oracle Database (ie below Standard and Enterprise Editions). There was no XE edition prior to the current 10gR2 version.
Application Express (Apex) is a web-based application environment that can work on a 9iR2 or higher Oracle database (any Edition). Apex v2.1 came pre-installed with XE and is specific to that Edition. All other Editions require that Apex is explicitly installed. (It will be interesting to see if that is still the case with the next version of the Oracle db.)
There used to be an 'Oracle Express' OLAP tool, just to confuse things a bit more. APEX and XE are less confusing terms than 'Express'.
|
|
|
Posts:
5,408
Registered:
06/19/04
|
|
|
|
Legend
|
|
Guru : 2500
- 1000000
pts
|
|
Expert : 1000
- 2499
pts
|
|
Pro : 500
- 999
pts
|
|
Journeyman : 200
- 499
pts
|
|
Newbie : 0
- 199
pts
|
|
Oracle ACE Director
|
|
Oracle ACE Member
|
|
Oracle Employee ACE
|
|
Helpful Answer
(5 pts)
|
|
Correct Answer
(10 pts)
|
|
