Keys in sql, PL-SQL Programming

Keys in SQL

SQL support for keys in the following respects:

  1. SQL does not require at least one key for every base table. If no key is explicitly declared, then KEY {ALL BUT} is implicit.
  2. When no key is specified there is no prohibition on multiple appearances of the same row.
  3. SQL does not recognize the empty set as a key.
  4. SQL allows a key to be a proper superset of another key for the same base table. (This "feature" is sometimes used as a workaround for the fact that the columns of the foreign key are required to correspond to those of a declared key of the referenced table.)
Posted Date: 1/18/2013 11:31:39 PM | Location : United States







Related Discussions:- Keys in sql, Assignment Help, Ask Question on Keys in sql, Get Answer, Expert's Help, Keys in sql Discussions

Write discussion on Keys in sql
Your posts are moderated
Related Questions
Package Specification The package specifications contain the public declarations. The scopes of these declarations are local to your database representation and global to the

Why Use Cursor Variables ? Primarily, you use the cursor variables to pass the query result sets between the PL/SQL stored subprograms and different clients. Neither PL/SQL nor

Logical Operators The logical operators AND, NOT, and OR follow the tri-state logic shown in table below. The AND and OR are binary operators; NOT is a unary operator.

Boolean Values Only the values TRUE, FALSE, & NULL can be assigned to a Boolean variable. For illustration, given the declaration DECLARE done BOOLEAN; the following statements

The accuracy of product table data is critical and the Brwebean's. owner wants to have an audit file that contains information regarding all DML activity on the BB_PRODUCT table. T

Closing a Cursor Variable The CLOSE statement disables the cursor variable. After that, the related result set is undefined. The syntax for the same is as shown below: CLOS

Using a Host Variable You can declare the cursor variable in the PL/SQL host environment like an OCI or Pro C program. To use the cursor variable, you should pass it as a host

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

EXIT-WHEN The EXIT-WHEN statement permits a loop to complete conditionally. Whenever the EXIT statement is encountered, the condition in the WHEN clause is computed. When the co

LIKE Operator You use the LIKE operator to compare the character value to a pattern. The Case is significant. LIKE returns the Boolean value TRUE when the character patterns mat