Hadoop

    Saved Searches

    You have no Saved Searches ...

    Breadcrumb

    Search Results

    All

    Results Timeline Dynamic

    • You can use the default clause to set a value for a column if you don't specify it on insert. You can use an expression or literal for the default value. If using an expression, the following restrictions apply:You can't use PL/SQL functionsYou can't use SQL queriesYou can't reference table columns in the expressionYou can't use the pseudocolumns LEVEL, PRIOR or ROWNUM
       
      Topic : Column Defaults
    • Temporal validity lets you link a valid time dimension with a table. Oracle supports the following data types for the columns storing the start and end of a period:datetimestamptimestamp with time zonetimestamp with local time zone
       
      Topic : Temporal Validity
    • 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
    • If PL/SQL code in your application contains dynamic SQL (EXECUTE IMMEDIATE, OPEN-FOR, DBMS_SQL), you should take steps to minimize the opportunity for SQL injection attacks.
       
      Topic : Page Security
    • You will learn how actions within Dynamic Actions are executed and how they interact with the ";Confirm"; action.
       
      Topic : Dynamic Actions
    • A CHECK constraint does not constrain the data only to those rows where the condition is TRUE. Rows where the condition is boolean UNKNOWN (NULL) is also allowed. It is better to think of a CHECK constraint as rejecting those rows where the condition is FALSE.
       
      Topic : Constraint DDL
    • 12c offers new features when it comes to retrieve the first relevant record in a set. This can be particularly useful for retrieving first record of correlated outer join (OUTER APPLY.)
       
      Topic : Row limiting clause
    • Anti-joins return rows from one table source where a join match has not been found in the other table source. It can be achieved in various ways, both using specific syntax (NOT IN / NOT EXISTS) as well as ";simulated"; with outer joins.
       
      Topic : Anti-joins
    • A variable declared with type POSITIVE can only have integer values 1 and higher. And since I assign the ";bad"; value in the declaration section, the VALUE_ERROR exception raised cannot be handled by the block's exception section.
       
      Topic : Exceptions Raised in Declaration Section
    • RETURN is used to return a value from within a function. But you can also use it in the form RETURN; to simply terminate execution in any block, including an anonymous block or a procedure.
       
      Topic : The RETURN Statement in Subprograms
    • You cannot referenced a packaged constant or variable in a SQL statement unless that statement is executed from within a PL/SQL block.
       
      Topic : Accessing PL/SQL Constants from SQL
    • 1 2 3 4 5 6 7 8 9 10  Next Set

    Filters

    Search Criteria