If a table column has is UNIQUE and has NOT NULL, is it
equivalent to a PRIMARY KEY column?
Answer Posted / kuldeep singh
Primary Key=Unique+Not Null+Sorting+Cluster Index
So
UNIQUE +NOT NULL != PRIMARY KEY
it cant refer someother table column
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to write a left outer join with the where clause in oracle?
What is Trigger in Oracle?
How to create a new view in oracle?
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)
What is coalesce function?
What happens if you use a wrong connect identifier?
How to start your 10g xe server?
How to retrieve data from an cursor to a record?
How to declare a local variable?
What is the difference between sharding and replication?
How to use "in out" parameter properly?
How to display row numbers with the records?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
What is flashback in Oracle?
How to insert a new row into a table in oracle?