Saved Searches

    You have no Saved Searches ...

    Breadcrumb

    Search Results

    All

    Results Timeline Dynamic

    • All About the PL/SQL Function Result Cache with Steven Feuerstein (Recorded Webcast Event)
      10.7 years ago

      The Function Result Cache, added in Oracle Database 11g, offers developers a way to dramatically reduce the amount of time it takes to retrieve data that is requested repeatedly by database sessions (specifically: when the same rows of a table are fetched much more frequently than they are changed). This cache is stored in the SGA, shared across all sessions in the instance, and automatically purged of "dirty data" by the Oracle Database. Every application running on Oracle Database 11g Release 1 or higher Enterprise Edition should be taking advantage of this feature. Best of all, there is minimal impact on your code to start using this feature!

       
      Oracle Contributor
    • Turbocharge our PL/SQL Code with Bulk Processing by Steven Feuerstein (Recorded Webcast Event)
      10.7 years ago

      The Function Result Cache, added in Oracle Database 11g, offers developers a way to dramatically reduce the amount of time it takes to retrieve data that is requested repeatedly by database sessions (specifically: when the same rows of a table are fetched much more frequently than they are changed). This cache is stored in the SGA, shared across all sessions in the instance, and automatically purged of "dirty data" by the Oracle Database. Every application running on Oracle Database 11g Release 1 or higher Enterprise Edition should be taking advantage of this feature. Best of all, there is minimal impact on your code to start using this feature!

       
      Oracle Contributor
    • How to Write PL/SQL Code You Can Actually Read with Steven Feuerstein (Recorded Webcast Event)
      10.7 years ago
      Software managers are very good at putting pressure on developers to "get the job done" as quickly as possible, so as to meet usually unrealistic deadlines. The end result? Software with way too many bugs in it, and with it applications that require lots of resources simply to fix those bugs and maintain the code. If we are going to build and deploy successful applications, we have to think not only about getting that application in production today, but also the cost of keeping it in production (and meeting user needs) for years to come. This session offers a range of tips and techniques to improve the readability of your code and make it easier to maintain/evolve that code over time. This webinar offers a wide-ranging set of techniques to make your code easy to understand and maintain over time. These techniques include: the use of subtypes and local modules; how to activate and check compliance with standards; and encapsulation (information hiding). After watching this webinar, you will be able to write code that minimizes the amount of development resources needed to maintain that code.
       
      Oracle Contributor
    • When and How to Write SQL in PL/SQL with Steven Feuerstein (Recorded Webcast Event)
      10.8 years ago
      Oracle PL/SQL makes writing SQL so darned easy – in fact, it is way too easy to write SQL. As a result, PL/SQL developers take SQL totally for granted, and very few organizations have any sort of guidelines in place for when, where and how to write SQL. The result? The same or similar SQL statements repeated throughout the application, making it very hard to optimize and maintain the code.
       
      This webinar starts by reviewing the role of SQL in PL/SQL applications, and the key challenges involved when writing SQL. We then step through the most important best practices for SQL construction, ranging from avoiding SQL repetition to full qualification of variable and column names.
       
      After viewing this webinar, you will be well positioned to establish and follow a set of guidelines for SQL construction that will have a significant impact on application performance and maintainability.
       
       
      Oracle Contributor
    • Creating and Running a Database Application Using Oracle Application Express 4.2 - (Recorded Webcast Event)
      11.6 years ago

      Watch how to create a web-based Database Application using Oracle Application Express 4.2. You will also see how to add a Mobile User Interface to the database application, thereby allowing users to access the application on a mobile device. Learn how to use a responsive theme in an application, so that the application can be viewed on any device such as desktops, mobiles, smartphones or tablets.

       
      Oracle Contributor
    • Creating and Using a RESTful Web Service in Application Express 4.2 (video)
      12.6 years ago

      The purpose of this video is to show you how to create a RESTful web service declaratively using Oracle Application Express SQL Workshop with the Application Listener, and then consume that same service using Oracle Application Expresses support for declaratively creating clients based on RESTful web services.

       
      Oracle Contributor
    • Packaged Application in Application Express 4.2
      12.6 years ago

      This demonstration shows you how to install and use a packaged application in Application Express Release 4.2.

       
      Oracle Contributor
    • Creating a Mobile Web Application Using Application Express 4.2
      12.6 years ago

      This demonstration provides an overview on how to create a Mobile Web Application using Application Express Release 4.2

       
      Oracle Contributor
    • Responsive Web Application Development with Theme 25 in Application Express 4.2
      12.6 years ago

      This demonstration provides an overview on how to use Theme 25 to create a responsive web application in Application Express Release 4.2

       
      Oracle Contributor

    Filters

    Search Criteria