Saved Searches

    You have no Saved Searches ...


    Search Results


    Results Timeline Dynamic

    • Complex Recordsets
      7 hours ago
      Build complex recordsets using temporary or PL/SQL tables within stored procedures.
      Topic : Temporary tables
    • Encrypt and decrypt data using the DBMS_OBFUSCATION_TOOLKIT package.
      7 hours ago
      Use this package and associated views to track session and long operation activity.
    • A brief overview of some of the important points you should consider when first trying to learn PL/SQL.
      Topic : Oracle PL/SQL
    • Manish steps you through the creation of an explicit cursor with a parameter that has a default value.
      Topic : Explicit Cursors
    • Manish shows you how to use a cursor FOR loop with an explicitly defined cursor.
      Topic : Cursor FOR Loops
    • Learn how to create a cursor for loop with one or more parameters by Manish Sharma.
      Topic : Cursor FOR Loops
    • An introduction to working with records in PL/SQL: includes blog post and video.
      Topic : Records
    • Manish explores how to define a record variable based on a relational table structure, using %ROWTYPE.
      Topic : The %ROWTYPE Attribute
    • Chris Saxon offers several alternatives to help solve a string matching issue: - Right pad your day strings with spaces up to 9 characters - Use the FM mask to remove trailing spaces - Use the DY mask and compare to the first three characters of the days (MON, TUE, WED, ...)
      Topic : TO_CHAR (datetime)
    • Got apps or services for Oracle Cloud? Learn how you can use Oracle Cloud Marketplace to sell your innovative apps and services directly to Oracle's worldwide customer base.

      Seize the opportunity to reach new prospects, create revenue, and grow your business.


    • 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
    • You can stop people running select * queries by creating virtual columns with expressions that raise an error.
      Topic : Virtual Columns
    • You can create check constraints to ensure strings only store certain characters. There are many ways you can do this. These include:Using regular expressions. These can validate that the string only contains valid characters or it doesn't contain invalid characters. In either case you must take care when writing the regex. These are easy to get wrong!Mapping the valid characters to null. Then checking that the final string is null. 
      Topic : Check Constraints
    • You can create partitioned indexes on non-partitioned tables. These either be range or hash partitioned. The syntax to do so is:create index <index_name> on <table_name> (<col1>, <col2>, ...)   global partition by (range|hash) (<col1>, <col2>, ...) (partitions N) ( <partitions> );The partitions N clause only applies for hash partitioned indexes. The partitions clause is optional for hash partitioning, but mandatory for range partitioned indexes. 
      Topic : Partitioned Indexes
    • 1 2 3 4 5 6 7 8 9 10  Next Set


    Search Criteria