10 Replies Latest reply on May 17, 2007 8:08 AM by John Edward Scott

    Application Express as front end

    571780
      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.
        • 1. Re: Application Express as front end
          Denes Kubicek
          The purpose of ApEx is to give you exactly that - a front end for your data.

          Denes Kubicek
          • 2. Re: Application Express as front end
            571780
            Actually what I meant was, can Oracle Database Express be used as the front-end to Oracle 10g.
            • 3. Re: Application Express as front end
              Denes Kubicek
              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
              • 4. Re: Application Express as front end
                4610
                User,

                If you meant developer 10g, then yes to that too. :)

                Chad
                • 5. Re: Application Express as front end
                  Dimitri Gielis
                  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
                  • 6. Re: Application Express as front end
                    135285
                    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/
                    • 7. Re: Application Express as front end
                      Denes Kubicek
                      The names XE (Express) and Application Express (ApEx) are
                      constantly confusing me. My answers in this thread can prove
                      that. This is the second thread this week, where I mixed
                      these two names, got involved into a discussion and
                      missed the point.

                      Denes Kubicek
                      -------------------------------------------------------------------
                      http://deneskubicek.blogspot.com/
                      http://htmldb.oracle.com/pls/otn/f?p=31517:1
                      -------------------------------------------------------------------
                      • 8. Re: Application Express as front end
                        571780
                        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?
                        • 9. Re: Application Express as front end
                          g.myers
                          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'.
                          • 10. Re: Application Express as front end
                            John Edward Scott
                            I wrote a blog post about APEX and XE a while back, because I kept getting asked what the differences were -

                            http://jes.blogs.shellprompt.net/2006/07/26/oracle-xe-application-express-and-the-great-divide/