Saved Searches

    You have no Saved Searches ...

    Breadcrumb

    Search Results

    All

    Results Timeline Dynamic

    • 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!

       
    • 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!

       
    • 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.
       
    • Learn how to run a script to update your database, review database objects in your database, create and debug a PL/SQL procedure and create an run a unit test in SQL Developer.

       
    • 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.
       
       
    • Recognizing patterns in a sequence of rows has been a capability that was widely desired, but not possible with SQL until now. There were many workarounds, but these were difficult to write, hard to understand, and inefficient to execute. With Oracle Database 12c Release 1 (12.1), you can use the MATCH_RECOGNIZE clause to perform pattern matching in SQL to do the following:

      1. Logically partition and order the data that is used in the MATCH_RECOGNIZE clause with its PARTITION BY and ORDER BY clauses.
      2. Define patterns of rows to seek using the PATTERN clause of the MATCH_RECOGNIZE clause. These patterns use regular expressions syntax, a powerful and expressive feature, applied to the pattern variables you define.
      3. Specify the logical conditions required to map a row to a row pattern variable in the DEFINE clause.
      4. Define output measures, which are expressions usable in the MEASURES clause of the SQL query.
      5. Control the output (summary vs. detailed) from the pattern matching process
       
    • Recognizing patterns in a sequence of rows has been a capability that was widely desired, but not possible with SQL until now. There were many workarounds, but these were difficult to write, hard to understand, and inefficient to execute. With Oracle Database 12c Release 1 (12.1), you can use the MATCH_RECOGNIZE clause to perform pattern matching in SQL to do the following:

      1. Logically partition and order the data that is used in the MATCH_RECOGNIZE clause with its PARTITION BY and ORDER BY clauses.
      2. Define patterns of rows to seek using the PATTERN clause of the MATCH_RECOGNIZE clause. These patterns use regular expressions syntax, a powerful and expressive feature, applied to the pattern variables you define.
      3. Specify the logical conditions required to map a row to a row pattern variable in the DEFINE clause.
      4. Define output measures, which are expressions usable in the MEASURES clause of the SQL query.
      5. Control the output (summary vs. detailed) from the pattern matching process
       
    • This tutorial introduces you to the basics of Oracle Text theme indexes and queries. It can all be run from SQL*Plus or SQL Developer and requires no additional files.

       
    • In this set of tutorials, you learn about Oracle Text. Oracle Text provides indexing, word and theme searching, and viewing capabilities for text in query applications and document classification applications.

       
    • An Oracle Text index is an Oracle Database domain index. To build your query application, you can create an index of type CONTEXT with a mixture of text and structured data columns, and query it with the CONTAINS operator.
      You create an index from a populated text table. In a query application, the table must contain the text or pointers to where the text is stored. Text is usually a collection of documents, but can also be small text fragments.

      This tutorial covers the following:

      • Creating a CONTEXT Index and Querying with CONTAINS operator
      • Creating a CTXCAT Index and Querying with CATSEARCH operator
      • Creating a CTXRULE Index and Querying with MATCHES operator
       
      Oracle Contributor
    • Oracle Text is well-known as the text searching engine within Oracle Database 12c. Oracle Text provides indexing, word and theme searching, and viewing capabilities for text in query applications and document classification applications. It is easy to use in any application which understands SQL and it is based on the extensibility framework within the Oracle kernel. Oracle Text is multilingual, and capable of managing many types of document.

      This tutorial covers the following topics:

      • How to create a user with the CTXAPP role.
      • How to build simple text query.
      • It also provides information about basic SQL statements for each type of application to load, index, and query tables.
       
      Oracle Contributor
    • This tutorial shows you how to install the Oracle Database 12c software on Microsoft Windows along with a default instance of an Oracle Database that contains example schemas ( including the HR schema).

       
    • This podcast is the first in a series of podcasts that will look at the core concepts behind Oracle’s in-database SQL analytics and examine, in detail, some of the key features and functions.

       
    • In this podcast we review the extensions to the SQL GROUP BY clause, which allow developers and business users to add subtotals and grand-totals to their result sets. These can range from simple row/column subtotals to the creation of sophisticated hierarchical, multi-dimensional cubes.

       
    • In this podcast we explore some examples of how to use SQL analytics to answer some typical business questions.

       

    Filters

    Search Criteria