Understanding Oracle Apex 5 Application Development

Author: Edward Sciore
Publisher: Apress
ISBN: 1484209893
Size: 53.41 MB
Format: PDF, ePub, Docs
View: 954
Download
This new edition of Understanding Oracle APEX 5 Application Development shows APEX developers how to build practical, non-trivial web applications. The book introduces the world of APEX properties, explaining the functionality supported by each page component as well as the techniques developers use to achieve that functionality. The book is targeted at those who are new to APEX and just beginning to develop real projects for production deployment. Reading the book and working the examples will leave you in a good position to build good-looking, highly-functional, web applications. Topics include: conditional formatting, user-customized reports, data entry forms, concurrency and lost updates, and updatable reports. Accompanying the book is a demo web application that illustrates each concept mentioned in the book. Specific attention is given in the book to the thought process involved in choosing and assembling APEX components and features to deliver a specific result. Understanding Oracle APEX 5 Application Development is the ideal book to take you from an understanding of the individual pieces of APEX to an understanding of how those pieces are assembled into polished applications. Teaches how to develop non-trivial APEX applications. Provides deep understanding of APEX functionality. Shows the techniques needed for customization.

Beginning Oracle Application Express 5

Author: Doug Gault
Publisher: Apress
ISBN: 1484204662
Size: 45.54 MB
Format: PDF, ePub, Mobi
View: 3154
Download
Whether you’re new to Oracle or an old hand who has yet to test the waters of APEX, Beginning Oracle Application Express 5 introduces the processes and best practices you’ll need to become proficient with APEX. The book shows off the programming environment, the utilities and tools available, and then continues by walking through the process of building a working system from the ground up. All code is documented and explained so that those new to the languages will not be lost. After reading this book, power users and programmers alike can quickly put together robust and scalable applications for use by one person, by a department, by an entire company. Beginning Oracle Application Express 5 introduces version 5 of the popular and productive Oracle Application Express development platform. Called APEX for short, the platform enables rapid and easy development of web-based applications that make full use of Oracle Database. The release of APEX 5 brings major new changes to the page builder, an enhanced universal theme, better RESTful web services support, enhanced application packaging, and the many redesigned wizards give a new and fresh feel to the user interface. Covers brand-new functionality in APEX 5 Provides fully documented and explained example code Guides you through creating a working and fully deployable application

Expert Oracle Application Express

Author: Doug Gault
Publisher: Apress
ISBN: 1484204840
Size: 66.61 MB
Format: PDF, Kindle
View: 5638
Download
Expert Oracle Application Express, 2nd Edition is newly updated for APEX 5.0 and brings deep insight from some of the best APEX practitioners in the field today. You'll learn about important features in APEX 5.0, and how those can be applied to make your development work easier and with greater impact on your business. Oracle Application Express (APEX) is an entirely web-based development framework that is built into every edition of Oracle Database. The framework rests upon Oracle’s powerful PL/SQL language, enabling power users and developers to rapidly develop applications that easily scale to hundreds, even thousands of concurrent users. APEX has seen meteoric growth and is becoming the tool of choice for ad-hoc application development in the enterprise. The many authors of Expert Oracle Application Express, 2nd Edition build their careers around APEX. They know what it takes to make the product sing—developing secure applications that can be deployed globally to users inside and outside a large enterprise. The authors come together in this book to share some of their deepest and most powerful insights into solving the difficult problems surrounding globalization, configuration and lifecycle management, and more. New in this edition for APEX 5.0 is coverage of Oracle REST Data Services, map integration, jQuery with APEX, and the new Page Designer. You’ll learn about debugging and performance, deep secrets to customizing your application u ser interface, how to secure applications from intrusion, and about deploying globally in multiple languages. Expert Oracle Application Express, 2nd Edition is truly a book that will move you and your skillset a big step towards the apex of Application Express development. Contains all-new content on Oracle REST Data Services, jQuery in APEX, and map integration Addresses globalization and other concerns of enterprise-level development Shows how to customize APEX for your own application needs

Beginning Oracle Application Express

Author: Rick Greenwald
Publisher: John Wiley & Sons
ISBN: 1118059379
Size: 39.19 MB
Format: PDF, Docs
View: 6822
Download
This book shows you how to master Application Express to build effective web-based Oracle database applications. The author provides hands-on, step-by-step guidance on the complete development process, through creating, customizing, and extending the application. In addition to presenting how to build a simple application, this guide also details reporting and charting, themes and templates, and security. Additionally, it demonstrates how to use packaged applications and how to work with multiple applications. Data migration and integration with the Oracle environment is also discussed.

Oracle Application Express Administration

Author: Francis Mignault
Publisher: Apress
ISBN: 1484219589
Size: 11.48 MB
Format: PDF, Docs
View: 2807
Download
Succeed in managing Oracle Application Express (APEX) environments. This book focuses on creating the right combination of scalability, high-availability, backup and recovery, integrity, and resource control. The book covers everything from simple to enterprise-class deployments, with emphasis on enterprise-level requirements and coverage of cloud and hybrid-cloud scenarios. Many books cover how to develop applications in Oracle APEX. It’s a tool with a fast-growing user-base as developers come to know how quick and easy it is to create new applications that run in a browser. However, just getting an application off the ground is only a small part of a bigger picture. Applications must be supported. They must be available when users need them. They must be robust against disaster and secure against malicious attack. These are the issues addressed in Oracle Application Express Administration. These are the issues that when tackled successfully lead to long term success in using Oracle APEX as a rapid application-development toolset. Readers of this book learn how to install the Oracle APEX engine in support of small-scale projects such as at the departmental level, and in support of enterprise-level projects accessed by thousands of users across dozens of time zones. Readers learn to take advantage of Oracle Database’s underlying feature set in regards to application scalability and performance, integrity, security, high-availability, and robustness against failure and data loss. Oracle Application Express Administration also describes different cloud solutions, integration with Oracle E-Business Suite, and helps in taking advantage of multitenancy in Oracle Database 12c and beyond. Covers important enterprise considerations such as scalability, robustness, high-availability. Describes cloud-based application deployment scenarios Focuses on creating the right deployment environment for long-term success What You Will Learn Install, upgrade, and configure robust APEX environments Back up and recover APEX applications and their data Monitor and tune the APEX engine and its applications Benefit from new administration features in APEX 5.0 Run under multi-tenant architecture in Oracle Database 12c Manage the use of scarce resources with Resource Manager Secure your data with advanced security features Build high-availability into your APEX deployments Integrate APEX with Oracle E-Business Suite Who This Book Is For Architects, administrators, and developers who want to better understand how APEX works in a corporate environment. Readers will use this book to design deployment architectures around Oracle Database strengths like multi-tenancy, resource management, and high availability. The book is also useful to administrators responsible for installation and upgrade, backup and recovery, and the ongoing monitoring of the APEX engine and the applications built upon it.

Beginning Oracle Sql

Author: Tim Gorman
Publisher: Apress
ISBN: 1430265566
Size: 54.62 MB
Format: PDF, ePub
View: 1954
Download
Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. These tools include SQL*Plus and SQL Developer. SQL*Plus is the one tool any Oracle developer or database administrator can always count on, and it is widely used in creating scripts to automate routine tasks. SQL Developer is a powerful, graphical environment for developing and debugging queries. Oracle's is possibly the most valuable dialect of SQL from a career standpoint. Oracle's database engine is widely used in corporate environments worldwide. It is also found in many government applications. Oracle SQL implements many features not found in competing products. No developer or DBA working with Oracle can afford to be without knowledge of these features and how they work, because of the performance and expressiveness they bring to the table. Written in an easygoing and example-based style, Beginning Oracle SQL is the book that will get you started down the path to successfully writing SQL statements and getting results from Oracle Database. Takes an example-based approach, with clear and authoritative explanations Introduces both SQL and the query tools used to execute SQL statements Shows how to create tables, populate them with data, and then query that data to generate business results What you’ll learn Create database tables and define their relationships. Add data to your tables. Then change and delete that data. Write database queries that generate accurate results. Avoid common traps and pitfalls in writing SQL queries, especially from nulls. Reap the performance and expressiveness of analytic and window functions. Make use of Oracle Database's support for object types. Write recursive queries to query hierarchical data. Who this book is for Beginning Oracle SQL is aimed at developers and database administrators who must write SQL statements to execute against an Oracle database. No prior knowledge of SQL is assumed. Table of Contents 1. Relational Database Systems and Oracle 2. Introduction to SQL and SQL*Plus, and SQL Developer 3. Data Definition, Part I 4. Retrieval: The Basics 5. Retrieval: Functions 6. Data Manipulation 7. Data Definition, Part II 8. Retrieval: Joins and Grouping 9. Retrieval: Advanced Features 10. Views 11. Automating 12. Object-Relational Features 13. Appendix A – Case Tables 14. Appendix B – Exercise Solutions

Oracle Application Express 3 2

Author: Arie Geller
Publisher: Packt Publishing Ltd
ISBN: 1847194532
Size: 40.50 MB
Format: PDF
View: 1318
Download
Developing data-centric web applications can be a real challenge as it is a multi-disciplinary process. There are many technologies involved in the client side (HTML, CSS, JavaScript, and so on); the interaction with the database, on the server side; the typeless nature of the web environment; and above all, the need to put it all together. This needs to be done in a manner that will allow the end users to do their job in the simplest and most efficient way, while enriching their user experience. How often have you wished that developing such applications could be uncomplicated and straightforward? This book will show you that it's possible, and teaches you how to do it, using Oracle Application Express (APEX). With this practical guide to APEX, you'll learn how to easily develop data-centric web applications for the Oracle environment. The book covers the development cycle of an APEX application, reviewing the major APEX principles and building blocks chapter by chapter. It starts with the basic skills you need to get going when developing with APEX. Later, you will learn advanced issues, such as how to build tailor-made forms and reports, using APEX APIs, AJAX, and so on. It not only deals with the "How" but also with the "Why", and before long you will be able to understand APEX concepts, and use them to expand and enhance the built-in features, wizards, and tools. The book starts with the design phase, including building the necessary database objects infrastructure; continues with ways to implement the application logic (on the server side) and the User Interface (on the client side), whilst showing you how to enhance your applications' features and functionality according to your specific needs; and it ends with application deployment. The book emphasizes and clearly documents areas such as Globalization, Localization, and developing multi-lingual applications, and includes a special discussion about Right-To-Left (RTL) support for APEX applications, documented here for the first time. Throughout the book, there are many screenshots and snippets of code, taken from working APEX applications. The book is accompanied by demo APEX applications that you can download and install in your APEX environment, thoroughly analyze, and learn from as you read the book.

Oracle Application Express Forms Converter

Author: Douwe Pieter van den Bos
Publisher: Packt Publishing Ltd
ISBN: 1847197779
Size: 19.56 MB
Format: PDF, Mobi
View: 3658
Download
Convert your Oracle Forms applications to Oracle APEX successfully using this book and eBook

Oracle Application Express By Design

Author: Patrick Cimolini
Publisher: Apress
ISBN: 1484224272
Size: 26.53 MB
Format: PDF, ePub, Mobi
View: 7168
Download
Learn the many design decisions that must be made before starting to build a large Oracle Application Express (APEX) application for the cloud or enterprise. One of APEX's key strengths is the fact that it is a Rapid Application Development (RAD) tool. This is also a major weakness when it tempts developers to start coding too soon. Small applications that consist of tens of pages can be coded without a lot of design work because they can be re-factored quickly when design flaws are discovered. Design flaws in large cloud and enterprise applications that consist of hundreds or thousands of pages are not so easy to re-factor due to the time needed to redevelop and retest the application, not to mention the risk of breaking functionality in subtle ways. Designing a large application before coding starts is a profitable exercise because a thoughtful design goes a long way in mitigating cost overruns and schedule slippage while simultaneously enhancing quality. This book takes into account perspectives from other non-developer stakeholders such as maintenance developers, business analysts, testers, technical writers, end users, and business owners. Overlooking these perspectives is one of the chief causes of expensive rework late in the development cycle. Oracle Application Express by Design illustrates APEX design principles by using architecture diagrams, screen shots, and explicit code snippets to guide developers through the many design choices and complex interrelationship issues that must be evaluated before embarking on large APEX projects. This book: Guides you through important, up-front APEX design decisions Helps you to optimize your design by keeping all stakeholders in mind Explicit code examples show how design impacts cost, schedule, and quality What You Will Learn Pick and choose from the list of designs before coding begins Bake optimal quality into the underlying fabric of an APEX application Think and design from outside the developer’s narrow perspective Optimize APEX application designs to satisfy multiple stakeholder groups Evaluate design options through hands-on, explicit code examples Define and measure success for large cloud and enterprise APEX applications Who This Book Is For APEX developers and development teams

Pro Jquery In Oracle Application Express

Author: Scott Wesley
Publisher: Apress
ISBN: 9781484209622
Size: 14.60 MB
Format: PDF, ePub
View: 7116
Download
Building on your existing SQL skills, this book teaches you how to apply useful jQuery techniques to applications developed using the Oracle Application Express (APEX) development tool. Pro jQuery in Oracle Application Express covers the fundamentals you need to start enhancing your applications, with some practical examples that you'll want in your own applications tomorrow. jQuery is a framework already utilized by APEX, and by learning the basics of jQuery you can leverage the flexible dynamic actions provide and see your applications raise the bar. Discover why you should embrace HTML5, CSS, and jQuery library capabilities, and how they can enhance the user experience. Oracle Application Express is a mature, browser-based, rapid-development environment with a strong community base around the #orclapex tag. jQuery is a language for the browser, with it you can treat your web page as if it were a database, interacting with a range of features and functions that can make you into a more constructive, more efficient developer. Exemplifies how productive APEX, CSS, and jQuery can be Transforms your PL/SQL skills to CSS and jQuery Provides jQuery snippets to enhance your application UX