Difference between primary key and unique key ?
Answer Posted / sreesakthi
primary key will not allow null values whereas unique key
will allow null values.we have only one primary key per
table,but we can have more than one unique key per table
Is This Answer Correct ? | 25 Yes | 8 No |
Post New Answer View All Answers
How to call a stored function with parameters?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
How to use "while" statements in oracle?
How do we create privileges in oracle?
Can a parameter be passed to a cursor?
How do I escape a reserved word in oracle?
various types of hints and their usage
Can we convert a date to char in oracle and if so, what would be the syntax?
How to start instance with a minimal initialization parameter file?
What are the uses of Database Trigger ?
types of indexes and the rationale behind choosing a particular index for a situation.
What is a view and how is it different from a table?
What is the order of defining local variables and sub procedures/functions?
Explain parameter file in oracle.
What is a connect identifier?