hi...
I am beginner for Oracle. Please anyone can tell me how we can assign primary key in to a particular field???????
johnsign11
0
Newbie Poster
Recommended Answers
Jump to PostThere are 2 ways to do it:
- as part of the create table statment like this
create table tab_1 (col1 number, col2 number, col3 number,
CONSTRAINT PK1 PRIMARY KEY (col1)) ;
- alter table tab_1 add CONSTRAINT PK1 PRIMARY KEY (col1) ;Enjoy.
Yaakov
All 4 Replies
jaakovb
0
Newbie Poster
NeverLift
0
Newbie Poster
debasisdas
580
Posting Genius
Featured Poster
yash_792
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.