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);
End to End Topics With SQL,PL/SQL,Reports,Forms,XML Reports,OAF,Oracle Apps
Home » SQL » Alter Table add Primary key Oracle
Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check oracleappstechnical.com
ReplyDelete