PRIMARY KEY - CONSTRAINT with examples | Oracle SQL tutorial in TAMIL

PRIMARY KEY - CONSTRAINT with examples | Oracle SQL tutorial in TAMIL | SQL tutorial for beginners in Tamil ‪@learncodetodaytamil‬
Hello Guys welcome to Learn Code Today தமிழ் 👩‍💻
Give this video a Thumbs Up 👍
Share & Subscribe for More Videos😉
Click the bell icon to get notified for new videos 🔔
feel free to drop your doubts in the comment section 📳
You can support me by buying a cup of coffee ☕ bit.ly/3wfnmrg
👍 Support: bit.ly/3Clr0E3
In this video we have discussed on what is constraint and its use.
what is primary key and advantages and what is column level constraint and table level constraint
00:25 - what is constraint
01:35 - Primary Key
03:02 - Column level primary key constraint
13:21 - Table level primary key constraint
DML - Delete: • DML - DELETE with ex...
DML - Merge: • DML - MERGE with exa...
DML - Update: • DML - UPDATE with ex...
DML - Insert: • DML - INSERT with ex...
DDL part 2: • DDL - (ALTER - Add, M...
DDL part 1: • DDL - (Create, Renam...
Relational operators: • Relational Operators w...
Datatypes in Oracle: • DATATYPES in SQL | Ora...
Channel link: / @learncodetodaytamil
Oracle SQL Playlist: • Oracle SQL in Tamil
#oracleintamil
#oraclesqlintamil
#oracledatabaseintamil
#whatisconstraintinoracleintamil
#whatisprimarykeyintamil
#columnlevelconstraint
#tablelevelconstraint
#advantagesofprimarykeyintamil
#columnlevelconstraintintamil
#tablelevelconstraintintamil
#primarykeywithexampleintamil
#user_constraint
#primarykeyconstraintintamil

[@venijesu7150]

Very excellent 👍🙏 so thanks sir

[@johnmelbinm972]

Thanks bro....for given this videos 😇

[@jeevaganmanickam8005]

Super bro

[@ananths1947]

Excellent teaching bro.....
You are the oracle doctor.

[@learncodetodaytamil]

Thanks and welcome

[@gunasundarigunasundari2478]

How to use constraints in alter command explain with example

[@SpiceShine3]

good in teaching,i can understand your way of explanation,one request please go little slow.thank you

[@learncodetodaytamil]

Sure! Thank you.

[@aiswaryabalan5068]

Whole table la single primary key create panurathu epdi bro

[@pradeepkumar-mk3ug]

Sir composite primary key videos podurenu soninga but podala

[@user-gi3wu9zf9l]

Hai sir , primary key la auto increment use pannalama

[@learncodetodaytamil]

Yes we can use it. This functionality is available from 12c. To use this we should use table level constraint.

[@manikp9939]

Hello sir, i have one doubt in table level constraints , please reply

[@learncodetodaytamil]

Yes, what is ur doubt..

[@ayyappanmani7669]

U ll take online sql class

[@johnmelbinm3236]

sir i can't see my table in user_tables...im trying many times...what i do?

[@learncodetodaytamil]

Use where condition. In where condition give table name in upper case within single quote.

[@LoveBgm1996]

bro if we does not give constraint name , how do we find the constraint name

[@learncodetoday3841]

U can find it under user_constraints ..

[@ayyappanmani7669]

Irukurathila intha topic custom ah iruku

[@princy_raj]

Why you gave E_PK primary key, explain what is E_PK

[@learncodetodaytamil]

E_PK Is the name of the primary key constraint...
U can provide any name... I have given _PK to easily identify that this is primary key constraint..

[@abdulrahaman9850]

Sir, do u have online course for SQL and PLSQL.

[@learncodetodaytamil]

Now I'm not taking any classes. We are planning to take classes after one or two months...

[@abdulrahaman9850]

@@learncodetodaytamil Noted Sir, please let me know in the same comment, so i will join when the class starts

[@learncodetodaytamil]

Sure

[@gunasundarigunasundari2478]

Check constraints using alter command give example and explaiN

[@learncodetodaytamil]

ALTER TABLE table_name
ADD CONSTRAINT constraint_name CHECK (column_name >= 0);

[@ayyappanmani7669]

Or work shop contact pannunga plz