Difference between primary key and unique key ?
Answer Posted / austin johnson
we can't insert a NULL value into to coloumn holding
primary key constrain.
where as we can insert a NULL value to a unique key feild.
Remember, both keys are used to identify the
rows/tuple/entry of the table uniquely.
so, only once u can enter a NULL value into the unique key
feild.
Is This Answer Correct ? | 146 Yes | 57 No |
Post New Answer View All Answers
what is the difference between data migration and production migration.
What is set operator oracle?
How many types of tables are there in oracle?
How to update values in a table in oracle?
what is the use of system.effective.date variable in oracle?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
What operating systems are supported by oracle database 10g xe?
How do we represent comments in oracle?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
Is there an oracle sql query that aggregates multiple rows into one row?
Use of an integrity constraint is better to validate data. Explain
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)
How to create a new oracle data file?
What is ordinary table in oracle?