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
Database Values You can use the SELECT statement to have the Oracle assign values to a variable. For Each and every item in the select list, there must be a matching, type-compa

Error Handling The PL/SQL makes it easy to detect and process the predefined and user-defined error conditions known as exceptions. Whenever an error occurs, an exception is ra

Parameter and Keyword Description: SQL: This SQL is the name of the implicit SQL cursor. %FOUND: This attribute results TRUE if an INSERT, DELETE, or UPDATE state

SQL Is a Database Language: The commands given to a DBMS by an application are written in the database language of the DBMS. The term data sublanguage is sometimes used instea

Opening a Cursor Variable The OPEN-FOR statement relates a cursor variable with the multi-row query, executes the query, and then identifies the result set. The syntax for ope

Using a Join on 2 tables, select all columns and all rows from the tables without the use of a Cartesian product. Query: SELECT * FROM EMPLOYEE1 JOIN CONTRACT ON EMPLOYEE

Declaring Subprograms   You can declare subprograms in any PL/SQL subprogram, block, or package. But, you should declare subprograms at the end of the declarative part after a

Keyword and Parameter Description: boolean_expression: This is an expression which results the Boolean value TRUE, FALSE, & NULL. It is related with a series of statement

Perform the following queries on the Hospital1.DB using SQL Anywhere (START EARLY!). a. Which patients have purchased the drug "Tylenol"? List the names and addresses. Arrange the

Procedural Constraint Enforcement (Triggers) SQL has an alternative method of addressing database integrity, involving event-driven procedural code. The special procedures th