Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Tuesday, 27 June 2017

Alter Table add Primary key Oracle


This is used to avoid duplicates and nulls. This will work as combination of unique and not null. Primary key always attached to the parent table.

 Alter Table add Primary key Example


SQL> ALTER TABLE student ADD PRIMARY KEY(no);
          SQL> ALTER TABLE student ADD CONSTRAINT pk PRIMARY KEY(no);
Share this article :

5 comments:

  1. Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check oracleappstechnical.com

    ReplyDelete
  2. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.

    ReplyDelete
  3. This would give you the affirmation that your picked locksmith doesn't originate from criminal components.24 hour locksmith gold coast

    ReplyDelete
  4. You can find out about what home improvement by visiting this home stylistic theme reference page.sea colony santa monica rent

    ReplyDelete
  5. Once I thought about things like: why such information is for free here? Because when you write a book then at least on selling a book you get a percentage. Thank you and good luck on informing people more about it… read here

    ReplyDelete