tag:blogger.com,1999:blog-8263561379184027662011-12-15T22:15:23.497-08:00Learning Application Express, APEX, ORACLE, ORACLE APEX, Instalation Application Expresssaeful uyunhttps://profiles.google.com/100073614588157994904noreply@blogger.comBlogger81100tag:blogger.com,1999:blog-826356137918402766.post-21421824641800124152009-06-26T00:12:00.000-07:002009-06-26T00:13:13.743-07:00

Adding a Lookup Table to Your ApplicationYou have also done the steps in this section before, so you can go through them quickly this time through.1. Return to your application and click on the master-detail page.2. Click on the item for CUSTOMER_NAME.You will want to make three changes to the attributes of this field.3. In the Name section of the page, change the Display As value to Select List

saeful uyunhttps://profiles.google.com/100073614588157994904noreply@blogger.com1tag:blogger.com,1999:blog-826356137918402766.post-54234252423361255012009-06-18T22:58:00.000-07:002009-06-18T22:59:26.305-07:00

Exporting the TableNow that you have set up the DSN, the Access Export wizard can use it. If you select a table inyour Access database and choose ODBC Databases from the Export menu, you will see the dialogbox shown in Figure 2-25. This dialog box allows you to name the table that will be createdby the Export wizard. For this example, we selected the Customers table and accepted thedefault

saeful uyunhttps://profiles.google.com/100073614588157994904noreply@blogger.com3tag:blogger.com,1999:blog-826356137918402766.post-79688946154204317492009-06-18T22:52:00.000-07:002009-06-18T22:58:18.996-07:00

To be able to configure the ODBC connection, you first need to have installed the Oracle clientsoftware and libraries on the machine from which you are exporting the data (the Windows XPmachine in this example). You can use many different ODBC drivers, including ones fromMicrosoft, Oracle, or third-party suppliers.We found that the easiest way to get up and running was to install the Oracle

saeful uyunhttps://profiles.google.com/100073614588157994904noreply@blogger.com0tag:blogger.com,1999:blog-826356137918402766.post-37315927022372220842009-06-17T23:07:00.000-07:002009-06-17T23:10:11.078-07:00

At the top of t his page, you can see four icons used to run your applicat ion and deal with administrative tasks connected with the application. You will learn more about the three icons for Supporting Objects, Shared Components, and Export/Import later in t he book.You can also see the pages t hat were automatically generated for you when you c reated the application. You could double-click on

saeful uyunhttps://profiles.google.com/100073614588157994904noreply@blogger.com0tag:blogger.com,1999:blog-826356137918402766.post-29835572252653440812009-06-17T23:00:00.000-07:002009-06-17T23:04:58.621-07:00

You can accomplish a lot on this page. You can specify any number of pages that will be part of your application with just a few clicks. Since you only have one table available right now, you will only create one set of pages but with a more fully populated database, you could create fairly sophisticated applica-t ion systems with the point-and-click methods of this page.That’s it! You will be

saeful uyunhttps://profiles.google.com/100073614588157994904noreply@blogger.com1tag:blogger.com,1999:blog-826356137918402766.post-27110151037785264902009-06-17T20:13:00.001-07:002009-06-17T20:13:45.729-07:00

Building an Application with Application Express1. Log into your APEX-hosted account2. Click on the Utilities icon, and use the cascading menus to select Data Load/Unload, and thenthe Load choice3. Click on the Load Spreadsheet Data icon in the Load page, which will bring up the page shown4. On this page, accept the (Load To) New table choice, but change the Load From choice toUpload File. Click

saeful uyunhttps://profiles.google.com/100073614588157994904noreply@blogger.com1tag:blogger.com,1999:blog-826356137918402766.post-47095252436709544362009-06-17T19:49:00.000-07:002009-06-17T19:51:19.654-07:00

How t o S ign U p f or a H osted A PEX A ccountOracle Corporation provides free hosted APEX accounts for your trial use. Signing up is an easy processthat will take you less than 2 minutes.Open your browser and go to http://apex.oracle.com, which is shown in Figure 1-4.Figure 1-4Click on the ❑ Sign up for an account link underneath the big red Login button, which willbring up the first page of

saeful uyunhttps://profiles.google.com/100073614588157994904noreply@blogger.com0tag:blogger.com,1999:blog-826356137918402766.post-26055546920702845942009-06-17T19:42:00.000-07:002009-06-17T19:48:58.069-07:00

Introducing Oracle Application ExpressWelcome to the world of Oracle technology. The book you are holding will give you all you needto start creating powerful, flexible, highly productive applications for yourself and your users.And the software included with this book will give you the path to even greater capabilities through abroad range of Oracle software. You are going to like it here.This

saeful uyunhttps://profiles.google.com/100073614588157994904noreply@blogger.com2