LEADER 11756nam 2200541Ia 450 001 9910960739103321 005 20240401174907.0 035 $a(CKB)3710000000057155 035 $a(Safari)9781782179672 035 $a(OCoLC)868297715 035 $a(FR-PaCSA)88849966 035 $a(MiAaPQ)EBC1389366 035 $a(FRCYB88849966)88849966 035 $a(EXLCZ)993710000000057155 100 $a20140117d2013 uy 0 101 0 $aeng 135 $aurunu||||| 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 10$aOracle APEX cookbook /$fMarcel van der Plas, Michel van Zoest 205 $a2nd ed. 210 $aBirmingham, UK $cPackt Pub.$d2013 215 $a1 online resource (1 v.) $cill 300 $a"Create reliable, modern web applications for desktop and mobile devices with Oracle Application Express"--Cover. 300 $aIncludes index. 311 08$a9781782179672 311 08$a1782179674 327 $aIntro -- Oracle APEX Cookbook Second Edition -- Table of Contents -- Oracle APEX Cookbook Second Edition -- Credits -- About the Authors -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe? -- Free Access for Packt account holders -- Instant Updates on New Packt Books -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Downloading the example code -- Errata -- Piracy -- Questions -- 1. Creating a Basic APEX Application -- Introduction -- Creating an APEX 4.0 application -- How to do it... -- How it works... -- Creating a simple form page -- Getting ready -- How to do it... -- How it works... -- There's more? -- Creating a simple report -- Getting ready -- How to do it... -- How it works... -- See also -- Implementing an interactive report -- Getting ready -- How to do it... -- There's more... -- Creating a chart -- Getting ready -- How to do it... -- There's more... -- Creating a map chart -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating a navigation bar -- Getting ready -- How to do it... -- There's more... -- See also -- Creating a list of values -- Getting ready -- How to do it... -- How it works... -- There's more... -- Including different item types -- Getting ready -- How to do it... -- Protecting a page using an authorization scheme -- Getting ready -- How to do it... -- How it works... -- There's more... -- Securing an application with Authentication -- Getting ready -- How to do it... -- Controlling the display of regions and items with Dynamic Actions -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating a computation -- How to do it... -- There's more... -- Creating an automated row fetch with a page process. 327 $aGetting ready -- How to do it... -- How it works... -- Putting some validation in a form -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Creating a report with PL/SQL Dynamic Content -- How to do it... -- 2. Themes and Templates -- Introduction -- Creating your own theme -- Getting ready -- How to do it... -- How it works... -- Importing a theme -- Getting ready -- How to do it... -- How it works... -- Creating a custom template -- Getting ready -- How to do it... -- There's more... -- Including images in your application -- Getting ready -- How to do it... -- How it works... -- There's more... -- Referencing CSS classes in your application -- Getting ready -- How to do it... -- How it works... -- Controlling the layout -- Getting ready -- How to do it... -- How it works... -- There's more... -- 3. Extending APEX -- Introduction -- Adding JavaScript code to your application -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating a tag cloud with AJAX -- Getting ready -- How to do it... -- How it works... -- Creating visual effects with JavaScript libraries -- Getting ready -- How to do it... -- How it works... -- There's more... -- Enhancing your application with the Google API -- How to do it... -- How it works... -- There's more... -- See also -- Including Google Maps -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Embedding multimedia objects in your application -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Creating a region selector -- Getting ready -- How to do it... -- How it works... -- Sending mail via APEX -- Getting ready -- How to do it... -- How it works... -- Uploading and downloading files -- Getting ready -- How to do it... -- How it works... -- There's more. 327 $aCalling APEX from an Oracle Form -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating a data upload page -- Getting ready -- How to do it... -- Using shipped files -- Getting ready -- How to do it... -- How it works... -- There's more... -- 4. Creating Websheet Applications -- Introduction -- Creating a websheet application -- Getting ready -- How to do it... -- How it works... -- See also -- Creating a page in a websheet -- Getting ready -- How to do it... -- Adding a navigation section to a page -- Getting ready -- How to do it... -- Implementing a datagrid -- Getting ready -- How to do it... -- How it works... -- See also -- Allowing multiple users access to a websheet -- Getting ready -- How to do it... -- How it works... -- Creating an enhanced datagrid from a spreadsheet -- How to do it... -- There's more... -- 5. APEX Plug-ins -- Introduction -- Creating an item type plug-in -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating a region type plug-in -- Getting ready -- How to do it... -- How it works... -- See also -- Creating a dynamic action plug-in -- Getting ready -- How to do it... -- How it works... -- Creating a process type plug-in -- Getting ready -- How to do it... -- See also -- Creating an authorization plug-in -- Getting ready -- How to do it? -- How it works... -- There's more? -- 6. Creating Multilingual APEX Applications -- Introduction -- Creating a translatable application -- Getting ready -- How to do it... -- See also -- Using XLIFF files -- Getting ready -- How to do it... -- How it works... -- Switching languages -- Getting ready -- How to do it... -- Translating data in an application -- Getting ready -- How to do it... -- How it works... -- 7. APEX APIs -- Introduction -- Updating a table with the hidden primary key -- Getting ready -- How to do it. 327 $aHow it works... -- Reading a checkbox programmatically -- Getting ready -- How to do it... -- Creating help functionality with apex_application.help -- Getting ready -- How to do it... -- How it works... -- There's more... -- Counting clicks with apex_util.count_click -- Getting ready -- How to do it... -- How it works... -- There's more... -- Setting default item settings with apex_ui_default_update -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating a background process with apex_plsql_job -- Getting ready -- How to do it... -- How it works... -- There's more... -- 8. Using Web Services -- Introduction -- Creating a SOAP web service reference -- Getting ready -- How to do it... -- How it works... -- See also -- Creating a REST web service reference -- Getting ready -- How to do it... -- How it works? -- There's more? -- Building a page on a web service reference -- Getting ready -- How to do it? -- How it works? -- There's more? -- Publishing a RESTful web service -- Getting ready -- How to do it? -- There's more? -- See also -- 9. Publishing from APEX -- Introduction -- Exporting to a comma-separated file -- Getting ready -- How to do it... -- How it works... -- Creating a PDF report -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating a report query -- Getting ready -- How to do it... -- How it works... -- Creating a report layout using Oracle BI Publisher -- Getting ready -- How to do it... -- How it works... -- Linking the report layout to the report query -- Getting ready -- How to do it... -- How it works... -- Calling a report from a page -- Getting ready -- How to do it... -- How it works... -- 10. APEX Environment -- Introduction -- Setting up a development environment using subscriptions -- How to do it... -- Debugging an APEX application -- Getting ready. 327 $aHow to do it... -- There's more... -- Debugging an APEX application remotely -- Getting ready -- How to do it... -- How it works... -- There's more? -- Deploying an application with SQL Developer -- Getting ready -- How to do it... -- Setting up version control with APEX and SVN -- Getting ready -- How to do it... -- Setting up a production environment using an Apache proxy -- Getting ready -- How to do it... -- Setting up the APEX Listener on Tomcat -- Getting ready -- How to do it... -- There's more? -- Creating an error handling -- Getting ready -- How to do it? -- How it works... -- Using packaged applications -- Getting ready -- How to do it... -- 11. APEX Administration -- Introduction -- Creating a workspace manually -- Getting ready -- How to do it... -- How it works... -- Creating a workspace by request -- Getting ready -- How to do it... -- There's more... -- Creating a user -- Getting ready -- How to do it... -- Adding a schema to your workspace -- Getting ready -- How to do it... -- How it works... -- Setting up a system message -- Getting ready -- How to do it... -- There's more... -- Setting up a workspace announcement -- Getting ready -- How to do it... -- There's more... -- Setting up news items on the home page -- Getting ready -- How to do it... -- There's more... -- Creating a site-specific task list -- Getting ready -- How to do it... -- How it works? -- Creating a public theme -- Getting ready -- How to do it... -- How it works... -- There's more... -- Locking a workspace -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating table APIs -- Getting ready -- How to do it... -- How it works... -- There's more? -- 12. Team Development -- Introduction -- Creating a list of features -- Getting ready -- How to do it... -- There's more... -- Creating and assigning To-dos -- Getting ready -- How to do it. 327 $aKeeping track of bugs in the Bugtracker. 330 $aAs a Cookbook, this book enables you to create APEX web applications and to implement features with immediately usable recipes that unleash the powerful functionality of Oracle APEX 4.2. Each recipe is presented as a separate, standalone entity and the reading of other, prior recipes is not required.It can be seen as a reference and a practical guide to APEX development.This book is aimed both at developers new to the APEX environment and at intermediate developers. More advanced developers will also gain from the information at hand.If you are new to APEX you will find recipes to start development and if you are an experienced user you will find ways to improve your productivity and efficiency and make the most of APEX to enhance your applications.A little knowledge of PL/SQL, HTML and JavaScript is assumed. 606 $aApplication software$xDevelopment 606 $aInternet programming 615 0$aApplication software$xDevelopment. 615 0$aInternet programming. 676 $a006 700 $aPlas$b Marcel van der$01797068 701 $aZoest$b Michel van$01797069 801 0$bUMI 801 1$bUMI 906 $aBOOK 912 $a9910960739103321 996 $aOracle APEX cookbook$94339140 997 $aUNINA