Saved Searches

    You have no Saved Searches ...


    Search Results


    Results Timeline Dynamic

    • In this three week Massive Open Online Course, collaborate with other developers and Oracle experts to learn how to develop beautiful front-end applications using the Oracle JavaScript Extension Toolkit (JET). This course is designed for intermediate to advanced JavaScript developers. Please be sure to read the course description to determine if this course is right for you.

      Problems registering? Please make sure you have saved your SSO profile and try again. Still not working? Send an e-mail to

    • (5:02) This tutorial demonstrates how to create interactive dashboards to display real-time data in Oracle Planning and Budgeting Cloud.

    • This tutorial covers the use of Oracle Big Data Spatial and Graph to perform spatial raster analysis

    • This tutorial covers the use of Oracle Big Data Spatial and Graph to perform spatial vector analysis

    • This tutorial shows you how to construct a JavaScript Object Notation (JSON) file to add multiple entities to Oracle Management Cloud at the same time.

    • (Duration: 9 mins) This video describes full data update functionality and workflow and provides a short demonstration of running a full data update.

    • (Duration = 11 mins) This video describes the incremental data update functionality and workflow and provides a short demonstration of running an incremental data update.

    • The DEPRECATE pragma, new to 12.2, makes it easy to identify deprecated program units and elements. You can then flag use of deprecated code via compile-time warnings, and even stop compilation of units that use them.
      Topic : Mark Code as Deprecated with PRAGMA DEPRECATE
    • Getting ready to use OATS for Load Testing
    • In this video tutorial, you will learn how to:

      • Locate colleagues in the directory, review their expertise and interests, see where they fit in your organization, and understand their significance to you.

      • Collaborate with your colleagues using tools that you are already familiar with.

    • Starting in Oracle Database 12c, you can use column defaults to auto-generate surrogate key values. You do this either by:Specifying a sequence as the column default. Creating identity columnsIdentity columns default to "generated always". This prevents you supplying your own values for the surrogate key. If you want to be able to overwrite these, you must specify: generated by default (on null)On null is optional. 
      Topic : Identity Columns
    • We can replace triggers with new DEFAULT options in 12c. This improves performance and centralizes all logic in the table definition instead of in PL/SQL inside triggers.
      Topic : Identity Columns
    • Foreign keys allow values that are all null, even when there is no matching null value in the parent table.If you have a compound FK, if any of its values are null in the child, the non-null values don't have to match values in the parent. In this case you can have values in the child not in the parent!
      Topic : Referential Integrity
    • Index-organized tables have a PCTTHRESHOLD property. This states the largest percentage of an index block a row can consume. If a row is larger than this, Oracle splits the row in two. The columns that exceed this limit go in an overflow segment. You can also state which column to split a row at with the INCLUDING clause. All columns after this go in the overflow segment. If you specify both PCTTHRESHOLD and INCLUDING, PCTTHRESHOLD takes priority. For example, your index org clause is: pctthreshold 5 including c2 overflowand there is another column, c1, listed before c2 in the table. If c1 causes a row to be greater than 5% of the block, Oracle splits here instead of at c2. Placing columns in an overflow segment frees up space in the index block. Thus Oracle can place more rows in each one.The default value for PCTTHRESHOLD is 50. 
      Topic : Index Organized Tables
    • A foreign key validates that the values in a set of columns in one table exist in another. To do this, all the columns you reference in the target table must be part of either a:Primary keyUnique constraint
      Topic : Referential Integrity
    • 1 2 3 4 5 6 7 8 9 10  Next Set


    Search Criteria