BI Publisher

    Saved Searches

    You have no Saved Searches ...

    Breadcrumb

    Search Results

    All

    Results Timeline Dynamic

    • (4:39) This tutorial demonstrates how you can import data using files stored locally or on the Cloud server into Oracle Enterprise Planning and Budgeting Cloud. You can run the import process immediately or set it to run based on a recurring schedule.

       
    • You can stop people running select * queries by creating virtual columns with expressions that raise an error.
       
      Topic : Virtual Columns
    • To remove a primary key, you need to run an alter table ... drop command. This can either use:The primary key clause alter table <table_name> drop primary key;The constraint clause. To use this, you must pass the name of the primary key constraint: alter table <table_name> drop constraint <primary_key_name>;
       
      Topic : Primary Keys
    • 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
    • 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
    • You can't use the following data types in a primary key column:LOB, LONG, LONG RAW, VARRAY, NESTED TABLE, BFILE, REF, TIMESTAMP WITH TIME ZONE, or user-defined typeYou can use a TIMESTAMP WITH LOCAL TIME ZONE in a primary key.
       
      Topic : Primary Keys
    • 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
    • Key to solving deductive logic puzzles is coming up with a strategy for identifying and discarding possibilities in a systematic fashion.
       
      Topic : Deductive Logic
    • Key to solving deductive logic puzzles is coming up with a strategy for identifying and discarding possibilities in a systematic fashion.
       
      Topic : Deductive Logic
    • Key to solving deductive logic puzzles is coming up with a strategy for identifying and discarding possibilities in a systematic fashion.
       
      Topic : Deductive Logic
    • Key to solving deductive logic puzzles is coming up with a strategy for identifying and discarding possibilities in a systematic fashion.
       
      Topic : Deductive Logic
    • Key to solving deductive logic puzzles is coming up with a strategy for identifying and discarding possibilities in a systematic fashion.
       
      Topic : Deductive Logic
    • Key to solving deductive logic puzzles is coming up with a strategy for identifying and discarding possibilities in a systematic fashion.
       
      Topic : Deductive Logic
    • Key to solving deductive logic puzzles is coming up with a strategy for identifying and discarding possibilities in a systematic fashion.
       
      Topic : Deductive Logic
    • Key to solving deductive logic puzzles is coming up with a strategy for identifying and discarding possibilities in a systematic fashion.
       
      Topic : Deductive Logic
    • 1 2 3 4 5 6 7 8 9 10  Next Set

    Filters

    Search Criteria