Domain Integrity Constraint in SQL | Default, Not Null and Check Constraints | Oracle Database

Oracle Database Full Course 👇👇

Don't forget to tag our Channel...!
#oracledatabase
#oracle
#sql
#sqlconstraints
#defaultconstraint
#notnullconstraint
#checkconstraint
#oraclesql
#oracle11g
#ask4help
#LearnCoding

|| Content ||
1. voice 🔊 :- akhilesh
2. writer ✍ :- ankush

Thank You
👌👌👌

[RavinderSingh-zxho]

Adding more to the context, we can apply DEFAULT constraint in two or more than two columns. It can be applied at the time of table creation or while altering the data type of a column.
Same goes with NOT NULL constraint ( can be added in 2 or more columns)
Same goes with CHECK constraint (can be added in 2 or more columns)
Hope it helps! 🙂

[noobgamer]

You told that default constrain is used in a signal coloum but in practical you are using it in 2 columns i am not understanding this part

[YGZone.]

NOTE :- this constraint only apply on single column
ya note likhwa ke fir sare column mai apply karwa deta ho bhaii notes banane mai problem hoti hai na samjh nahi aata jo bol rhe ho wo right hai ya uska bad kuch or bolna lga wo right hai

[gauravsingh]

Sir check constraint main alter table amit modify adrs check ; but it is not showing right

[naziable]

Very well explained. Thanks a ton, Sir! :)

[shivamsinha]

Thankyou so much sir 🙏 very clearly explained 😊

[sonal]

Your explanation way is.. Too good.. Keep going.. 😊😊

[Dm-cv]

Sir Everyone can add not null constraints more than one column

[gauravsingh]

Sir ek baat samjh nhi aayi default value single column main laga lenge tho hum aur column main nhi laga payenge aisa bola then alter ke help se phir aapne different column main kaise laga diya iska solution bataiye

[gauravsingh]

Sir, please tell me one thing if I want to know which constraints is using there how can I get to know sir

[AhmadAli-spsp]

If we want to accept only character values not numbers .how to do ?

[shivam_prajapatii_]

primary key and forgin key ka video banaiye sir please

[divyanshsahu]

Sir jab apne default constraint use kiya to anish aur altaf me apply kyu nii hu

[rkiijto]

Sir JAVA full course per video banayiye na please 🙏🏻

[ifrahsami]

Jab alter use kia hai default ma to 2 ma hi eid kyun change hui baqe sab ki kyu nae hui??

[sayedmuntaz]

to fir value add karna compulsory dikha raha hai chahe o sroll me ho ya koi or row me in not null use

[vishalathawale]

sir plzzz advance java ka session dalo na, jdbc, servlet aur

[asifameer]

Ms excel power point tabs pe vedio banaien sir

[Dance_with_Ak]

Sir where are you from I am from Jamshedpur

[mr.shankarbandgar]

Sir plz muze sql ke notes chahiye.. 🙏