Massive Discounts - Ending Soon Limited Offer

Amazon Countdown Deals Closing Soon

Guaranteed Lifetime Commissions - Easy Sell and Unlimited

>
Results 1 to 4 of 4
  1. #1

    constraints used in Oracle ?

    Hello Dear,

    Please Tell Me What are the various constraints used in Oracle ?

  2. #2
    - not null.
    - primary key.
    - unique.
    - foreign key.
    - check.
    Cheap VPS Hosting | Cheap cPanel VPS
    Cheap Dedicated Servers | Free IPMI | Unmetered Bandwidth

  3. #3
    • NOT NULL. Specifies that this column cannot hold NULL values (constraints of this type are not nameable).
    • PRIMARY KEY. Specifies the column that uniquely identifies a row in the table. ...
    • UNIQUE. Specifies that values in the column must be unique.
    • FOREIGN KEY. ...
    • CHECK.

  4. #4
    Join Date
    Nov 2019
    Posts
    10
    NOT NULL Constraint − Ensures that the value of the column can not be NULL.


    DEFAULT Constraint − Sets the default value for the column when none is specified.


    UNIQUE Constraint–Ensures that all values in the column are distinct.


    PRIMARY Key − Also recognizes each row / record in the database table.


    FOREIGN Key − Identifies a row / record in any given database table.


    CHECK Constraint − The CHECK constraint guarantees that all values in the column satisfy those conditions.


    INDEX − Used to quickly create and retrieve data from the database.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Ad Here