Effects of null for unique specification - sql, PL-SQL Programming

Effects of NULL for UNIQUE Specification

When a UNIQUE specification u for base table t includes a column c that is not subject to a NOT NULL constraint, the appearance of several rows having NULL in place of a value for c and equal values for the other columns specified in u is permitted. It is only when each column of the specified "key" has a value that those column values may not appear in the same combination in more than one row of t.

Posted Date: 1/18/2013 11:32:32 PM | Location : United States







Related Discussions:- Effects of null for unique specification - sql, Assignment Help, Ask Question on Effects of null for unique specification - sql, Get Answer, Expert's Help, Effects of null for unique specification - sql Discussions

Write discussion on Effects of null for unique specification - sql
Your posts are moderated
Related Questions
1. Create a procedure called TAX_COST_SP to accomplish the tax calculation task. Keep in mind that the state and subtotal values are inputs into the procedure and the procedure is

Entering and Exiting If you enter the executable part of an autonomous routine, the major transaction suspends. When you exit the routine, the major transaction resumes. To ex

Parameter and Keyword Description: cursor_variable_name: This identifies a cursor variable or the parameter formerly declared within the present scope. host_cursor_va

Using Savepoints The scope of the savepoint is a transaction in which it is defined. The Savepoints defined in the major transaction are not related to the savepoints defined

Example of Tables within a Table - SQL Example: Obtaining C_ER from COURSE and EXAM_MARK SELECT CourseId, CAST (TABLE (SELECT DISTINCT StudentId, Mark FROM EXAM_MARK AS EM

Due to an increase in overhead costs, the buying price of all items needs to be increased. Management wants to see a report before deciding how much each product will go up. Add to

TYPES OF EVOLUTION - Sequential evolution                  :                    Minor changes in the gene pool of a population from one generation to the next, with the resul

IN Operator The operator IN tests the set membership. This means "equal to any member of." The set may have nulls, but they are ignored. For illustration, the statement below do

Table Represents an Extension - SQL It describes how each tuple in a relation represents a true instantiation of some predicate and each true instantiation is represented by s

Cursor Variables:   To execute the multi-row query, the Oracle opens an unnamed work region that stores the processing information. You can use an explicit cursor that names