This is a video tutorial by Kishan mashru on primary key constraint in oracle SQL, the video firstly explains what primary key constraint is and how it can be used along with its various limitations, then the video gives perfect examples to understand how to create a primary key at the column level i.e inline declaration, or at the table level i.e out of line declaration. The video gives the demonstration on ALTER TABLE ADD CONSTRAINT and ALTER TABLE DROP CONSTRAINT statements to add and drop primary keys from a table.
Subscribe to the channel : / @kishanmashru
Other Playlists:
Data Warehousing Concepts: • Data Warehousing Concepts
Python and Database: • Python | How to Install python packages
SQL and PL/SQL Interview Questions: • SQL AND PL/SQL INTERVIEW QUESTIONS
SQL and PL/SQL concepts: • SQL and PLSQL
Content and video created by : Kishan Mashru