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

best of best

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

Which software is this?

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

Nice 👍 video sir thanks 🙏🙏

Sir Everyone can add not null constraints more than one column

Sir can I get your address , just for some consultation .. Sir where doo you live in.. jamshedpur

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

Sir where are you from I am from Jamshedpur

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

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

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! :)

please make a vedio for PL also.

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 check constraint main alter table amit modify adrs check ; but it is not showing right

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

Sir plz muze sql ke notes chahiye.. 🙏

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 .....

arreh bhosrike tu phle bolna sheekh bc itni buri awaj mne ajtk nhi suni🤮🤮🤮

Thank you so much

Thankyou so much sir 🙏 very clearly explained 😊

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

primary key and forgin key ka video banaiye sir please

Very very helpful video. Thank you💯💯

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

Sir JAVA full course per video banayiye na please 🙏🏻

Hello Sir , Happy Independence Day

Ms excel power point tabs pe vedio banaien sir

Nice video ..
Easy to learn...

Section _ a

Tq sir

Congratulations 👎💗💗💟

Sound is not audible