Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is the difference between column level constraints and
table level constraints?

Answer Posted / pcsenthil

we can achive all type of constraint in both level but we
cannot use NOT NULL in table Level, the reason was "All
Constraint will give logical view to that particular column
but NOT NULL will assign to the structure of the table
itself.. that's why we can see NOT NULL constraint while
Describe the table, no other constraint will be seen.

Is This Answer Correct ?    17 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to store pictures on to the database?

928


What are the extensions used by oracle reports?

1000


How do I escape a reserved word in oracle?

1139


how can we store any pdf file in oracle

2104


How would you begin to troubleshoot an ORA-3113 error?

2035


How would you best determine why your MVIEW couldnt FAST REFRESH?

1846


What is ASM (Automatic Storage Management) in Oracle?

1139


How to use an explicit cursor without open statements?

1017


Explain an exception?

935


What is the exact use of Collections?

2104


What is format trigger?

2022


ABOUT IDENTITY?

2014


What is ordinary table in oracle?

1082


Can we protect our pl/sql source code?

995


How to create a new user account in oracle?

964