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 / hari

Column level and Table level Constraint

In column level we will give primary key after the data type
create table table-name(name varchar2(10) primary key)


In Table Level we will use constraint name..

Is This Answer Correct ?    19 Yes 29 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2383


How to use null as conditions in oracle?

1121


How to import one table back from a dump file?

1081


Is oracle the best database?

1004


How to invoke the data pump export utility?

1248


How to get a list of all user accounts in the database?

1129


Explain enable novalidate constraint.

1129


What is a nvl function?

1092


what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2230


Explain the use of grant option in imp command.

1078


When do we use group by clause in a sql query?

1098


How can we find out the current date and time in oracle?

1129


Explain a private synonyms?

1092


How to use values from other tables in update statements using oracle?

1119


What are the different types of trigger and explain its various uses and functions?

1164