Domain Integrity Constraint in SQL | Default, Not Null and Check Constraints | Oracle Database
HTML-код
- Опубликовано: 13 авг 2021
- Oracle Database Full Course 👇👇
• Oracle Database | SQL
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
👌👌👌
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! 🙂
Very well explained. Thanks a ton, Sir! :)
Thankyou so much sir 🙏 very clearly explained 😊
Your explanation way is.. Too good.. Keep going.. 😊😊
Very very helpful video. Thank you💯💯
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 .....
Same doubt
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
Nice video ..
Easy to learn...
Nice 👍 video sir thanks 🙏🙏
Sir check constraint main alter table amit modify adrs check ; but it is not showing right
Thank you so much
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
Sir Everyone can add not null constraints more than one column
best of best
Sir, please tell me one thing if I want to know which constraints is using there how can I get to know sir
primary key and forgin key ka video banaiye sir please
Sir JAVA full course per video banayiye na please 🙏🏻
please make a vedio for PL also.
If we want to accept only character values not numbers .how to do ?
Congratulations 👎💗💗💟
Sir jab apne default constraint use kiya to anish aur altaf me apply kyu nii hu
Jab alter use kia hai default ma to 2 ma hi eid kyun change hui baqe sab ki kyu nae hui??
sir plzzz advance java ka session dalo na , jdbc, servlet aur jsp.....
to fir value add karna compulsory dikha raha hai chahe o sroll me ho ya koi or row me in not null use
Ms excel power point tabs pe vedio banaien sir
Sir where are you from I am from Jamshedpur
Hello Sir , Happy Independence Day
Sir Please Reply Java Full Course ke bare main
Tq sir
Section _ a
Sir plz muze sql ke notes chahiye.. 🙏
Sir can I get your address , just for some consultation .. Sir where doo you live in.. jamshedpur
Sound is not audible
Which software is this?
It's Oracle 11g 🙂
@@LearnCodingOfficial tq sir