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.
Sir Can you help me with one problem?
I want to connect a MADE java Application GUI(in Netbeans) with Oracle database 11g (But with Primary Key Constraint,i cannot use Primary key in Oracle Database)
Can you give me any documentation and advice for an Java Application? And Thanks for your hard work on youtube ! Keep it Up
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.
Russian women it is unique essences. They put family above al. They are always ready to offer the outstanding career to be with the husband and children. If you will give her a little attention, love and care, if you will show her that you appreciate her as the wife and the mistress of the house, will admire with her beauty and wit, she will be true to you to the death. The grateful woman will make you in 100 times more happily if you estimate her diligence and will love her. I wish you to meet on my site the fine Russian girl who becomes to you the excellent wife and the partner, who will fill your life with love and happiness!
Marriage agency City of Russian Brides is an dating and marriage service for singles who wish to meet most beautiful Ukrainian and Russian ladies for correspondence and marriage. We provide true pictures and information of real, beautiful, sexy, intelligent, educated ladies. Welcome to A City of Brides - online photo personals mail order bride catalog of single women from Russia looking for dating and marriage worldwide. Please, bookmark our site now Our database is frequently updated. So, please visit our profiles gallery single women now. And dont forget to visit us next time.
Over recent years in the internet more and more myths emerge connected with Russian brides (under a term ‘Russian’ one should understand Ukrainian, Belarussian and Moldavian girls. We will try to explain where there is truth and where there is invention. In this respect many characteristics of Ukrainian girls and mysterious traits of a Russian soul will become understandable for you. Facts, statistics, opinion of experts, interesting articles collected in a FAQ format – you can find all this on our site.