Oracle - SQL - Unique Constraint

Oracle - SQL - Unique Constraint
Watch more Videos at www.tutorialsp...
Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.

[@TutorialsPoint_]

To Get Certification, Click Here: bit.ly/4537Uyk Use coupon "KZbin12" to get ‘’FLAT 12%’’ OFF at Checkout.

[@dhaneshpt8641]

Thank you...

[@KalyanS]

Nice Presentation. good work.

[@abhisheksrivastava9307]

Simple ways to add constrain is like alter table Employees modify(MobileNo unique); alter table Employees modify(EmailId primary );

[@AMITDAS-mr8xj]

can u just tell me one thing, if we apply the UNIQUE constraint to multi-columns it will check the uniqueness of combinations if we've already added (for reference2:50) 1 in first and 2 in second column we cant repeat the same dataset (that is 1-2) but can we repeat 2-1 that means 2 in first column and 1 in second column will it be unique data entry then ?

[@vibhoreaggarwal3444]

​@@AMITDAS-mr8xj Yes (2-1) will be considered as unique combination if it is occurring for the first time.

[@AMITDAS-mr8xj]

can u just tell me one thing, if we apply the UNIQUE constraint to multi-columns it will check the uniqueness of combinations if we've already added (for reference2:50) 1 in first and 2 in second column we cant repeat the same dataset (that is 1-2) but can we repeat 2-1 that means 2 in first column and 1 in second column will it be unique data entry then ?

[@muhammadyasar9764]

Thank you sir.

[@Jfresh55]

What happens when a code is thrown for an attached excel sheet? Is the excel sheet the issue or is it the backend code?

[@BoxerDogs]

At 3:29, under the column description you have '2' before the column name. I always thought you had to start with a column name. What does the '2' signify?

[@BoxerDogs]

I think I understand now.

[@anilamurtha2034]

kzbin.info/www/bejne/mmfUd4anZrhnlbs

[@morningstar2728]

Good

[@anilamurtha2034]

kzbin.info/www/bejne/mmfUd4anZrhnlbs

[@ALIkhan-kx4pi]

nice bro bht achy sy samjya ha thankxx

[@anilamurtha2034]

kzbin.info/www/bejne/mmfUd4anZrhnlbs

[@shaivisshowtime2021]

unique constraints wont be visible with desc, so is there any way we can check the type of constraints present on each column level?

[@johndavid9545]

kzbin.info/www/bejne/sGqvZINrZdKWp6s

[@darshanfr4207]

All detail of employee who's salary is greater than 1000 less than 5000. Give me ans

[@softmusic8057]

Is this is a tuple uniqueness constraint

[@anilamurtha2034]

kzbin.info/www/bejne/mmfUd4anZrhnlbs

[@AMITDAS-mr8xj]

@@anilamurtha2034 can u just tell me one thing, if we apply the UNIQUE constraint to multi-columns it will check the uniqueness of combinations if we've already added (for reference2:50) 1 in first and 2 in second column we cant repeat the same dataset (that is 1-2) but can we repeat 2-1 that means 2 in first column and 1 in second column will it be unique data entry then ?