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
Advantages of PL/SQL The PL/SQL is a high-performance transaction processing, completely portable language that offers the following advantages as shown: 1) Support for SQL

Using DELETE This process has three forms. The DELETE removes all elements from the collection. DELETE(n) removes the nth element from the nested table. When n is null, then D

Multiset types - SQL An SQL multiset is what in mathematics is also known as a bag-something like a set except that the same element can appear more than once. The body of an

MECHANISTI S THEORY-HAECKEL (1866) - Haeckel stating that after each catalysm, some new organism suddenly forms as a chance event in one stride from inanimate matter and sub

Relational Operators The relational operators permit you to compare randomly complex expressions. The list below provides the meaning of each operator:

Usefulness of Data Type In SQL, as in most computer languages, a type can be used for constraining the values that are permitted to be used for some purpose. In particular, i

heap sort program in pl/sql

Example of Alternative formulation as a table constraint Example: Alternative formulation as a table constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Must_be_enrolled_to_

Declaring Records Whenever you define a RECORD type, you may declare records of that type, as the illustration shows: DECLARE TYPE StockItem IS RECORD ( item_no INTEG

Map and Order Methods: The values of the scalar datatype like CHAR or REAL have a predefined order that allows them to be compared. While, the instances of an object type has