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
WHEN or THEN Key Constraints Suppose a table has two columns representing a period of time throughout which the information conveyed by the other columns is recorded as having

What Is a Package? The package is a schema object that group logically related PL/SQL items, types, and subprograms. The Packages usually have 2 parts, a specification & a bo

Avoid the NOT NULL Constraint In the PL/SQL, using the NOT NULL constraint incur a performance cost. Consider the illustration as shown below: PROCEDURE calc_m IS m NUMB

Majority of Differences among 9i, 10G, 11G :- These are some combine feature which has differences among others. Automatic Workload Repository (AWR) Drop database' s

Substitution and Instantiation - SQL It shows how NULL might appear in substitution for a parameter of a predicate and how it might thus participate in instantiation of that p

Cursor FOR Loops In most cases that need an explicit cursor, you can simplify the coding by using a cursor FOR loop rather of the OPEN, FETCH, and CLOSE statements. A cursor FO

Description: Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that pr

Parameter and Keyword Description: record_type_name: This identifies the user-defined type specifier that is used in the subsequent declarations of the records. NOT N

Mutual Recursion The Subprograms are mutually recursive if they directly or indirectly call each other. In the illustration below, the Boolean functions odd & even, that dete