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
On occasion, some of Brewbean's customers mistakenly leave an item out of a basket already checked out, so they create a new basket containing the missing items. However, they requ

Overriding Default Locking By default, the Oracle locks the data structures for you automatically. Though, you can request exact data locks on rows or tables when it is to you

Manipulating Collections Within PL/SQL, the collections add procedural power and flexibility. The biggest benefit is that your program can compute subscripts to process the spec

UPDATE Statement   The UPDATE statement transforms the values of the specified columns in one or more rows in the table or view. Syntax:

Raise_application_error -  procedure of package DBMS_STANDARD , allows to issue an user_defined error messages by stored sub-program or database trigger.

DBMS_OUTPUT: The Package DBMS_OUTPUT enables you to display output from the PL/SQL subprograms and blocks, that makes it easier to test and debug them. The procedure put_ line

Block Structure The PL/SQL is a block-structured language. That is, the fundamental units (procedures, anonymous blocks, and functions) that make up a PL/SQL program are logi

%ROWTYPE: This attribute gives a record type which represents a row in the database table or a row fetched from a formerly declared cursor. The Fields in the record and corresp

Accessing Attributes: You can refer to an attribute only by its name not by its position in the object type. To access or modify the value of an attribute, you can use the dot

V ariables and Constants in PL/SQL The PL/SQL permits you to declare constants and variables, and then use them in SQL and procedural statements anywhere in the expression. Th