Blog link: http://www.rebellionrider.com/sql-primary-key.htm
SQL tutorial on Primary key / SQL Primary key,
In this tutorial you will learn about
simple primary key, composute primary key, how to drop primary key. defining primary key using create table and alter table along with many other things.
Tool used in this tutorial is SQL Developer.
This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training.
Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage
Thanks for linking, commenting, sharing and watching more of our videos
This is Manish from RebellionRider.com
So Primary Key
There are two types of Primary keys
First is Simple primary Key: Primary key which Involves only one column and
Second is Composite Primary Key: Primary Key which involves more than one column.
We will start with Simple primary key.
You can create Primary key either with Create Table statement of by using Alter table Statement.
Let's define simple primary key using create table statements.
With create table statement we can either define primary key at column level or at table level.
We will start with defining Primary key at column level using create table statement.
You just have to put keyword Primary key after data type and size of column while defining a column of a table. Here oracle server will create a primary key on product id with default constraint name which will be slightly difficult to understand. You can give your own name to your constraint which is also a good practice.
Error report -
ORA-00911: invalid character
00911. 00000 - "invalid character"
*Cause: identifiers may not start with any ASCII character other than
letters and numbers. $#_ are also allowed after the first
character. Identifiers enclosed by doublequotes may contain
any character other than a doublequote. Alternative quotes
(q'#...#') cannot use spaces, tabs, or carriage returns as
delimiters. For all other contexts, consult the SQL Language
when i try to execute this query
CREATE TABLE customer
cust_id NUMBER(3) PRIMARY KEY,
anyone help please
One of the best tutorial class with all the details...Keep Going...
1.I created a table ,and I want to add Primary Key to a table 'Name'.but the name column have null and duplicate values,What should I do?? Can I add it if not what should I do,I dont want any other column as PK but name has the above issues.
2.Can You make a video on various level Certification on Oracle in detail...
+zohaib khalid I suggest you to read this blog on my website http://bit.ly/primary-key at the end of the article I explained how to drop a primary key constraint. Thanks Do make sure to share it with others
First of all I am a hug fan. It is incredible the way you simplify things.
While going through this tutorial I didn't understand the concept of Composite Key.
Because referring to the example you have shown here. I am still having duplicate values for phone number but unique values for customer id.
Cute girls groups. This hot chick Monica was willing to bathe and get suntanned on this sunny summer day that’s why she invited three guys to make her a company on the river coast. Could she ever imagine that these frisky guys would want something more than just sitting and talking about nothing? Well, she very quickly found out that when the young boys see a charming chick in tiny bikini everything they can think about is hard fuck! They started pounding her in the river and then moved to a more comfortable place where all three in turns stuck their peckers in her wonderful mouth and then bent her over and diddled in pussy and ass without any mercy trying to reach the peek of pleasure and cover the skin with loads of semen.
Cute girls are made to be fucked)) And the cuter they are, the better and dirtier fuck session can be expected. HardFuckTales can offer you something really out of the ordinary – handsome beefy guys stuff their rock hard dicks in the deep wet mouths then pulsating pussies and tight asses of hot spoiled girls in public places which makes the action even more exciting. Not to be missed!
Categories:One On OneBig BoobsInterracial18+ TeenAsianFacial Cumshot Latina Swallow Tattoo Brunette Blonde Bubble Butt
Overview:Now that theyre finally out of Mom and Dads house, they can fuck whoever they wanna fuck, all day long, and thats just what they do! Watch these naughty coeds skip class and show some ass, among other things as they suck and fuck their way through their higher education years