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
DELETE Statement The DELETE statement eliminates whole rows of data from the specified table or view. Syntax:

Using NOT NULL Besides assigning an initial value, the declarations can impose the NOT NULL constraint, as the example below shows: acct_id INTEGER(4) NOT NULL := 9999; You ca

Natural Join - SQL In the absence of NATURAL JOIN Example has to be replaced by something rather more longwinded, as shown in Example. Example: Joining IS_CALLED and IS_EN

Hi there, I have the final part of a submission to do, it is a demonstration that takes place tomorrow. I do not have to use previous information, but i have resources that sho

Using the student and faculty tables create a select query that outputs all students for a specific advisor. Generate the execution plan, select out the explain plan . Create an

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

Forward Declarations The PL/SQL needs that you declare an identifier before using it. And hence, you should declare a subprogram before calling it. For illustration, the decla

Question: a) Given the following relation: Location(loc_id, bldg_code, room, capacity) The underlined field is a primary key. (i) Write a PL/SQL program using the impl

Transaction context As the figure shows, the major transaction shares its context with the nested transactions, but not with the autonomous transactions. Similarly, If one aut

%ROWCOUNT The %ROWCOUNT yields the number of rows affected by the INSERT, UPDATE, or DELETE statement, or returned by a SELECT INTO statement. The %ROWCOUNT yields zero when a