Difference between primary key and unique key ?
Answer Posted / rakesh dwivedi
1.Primary key can not have null.Instead of it unique can have null at lest single time null.
2 In a table only one primary key exist.Unique can be multiple in table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to export data with a field delimiter?
How to use "for" statements in oracle?
How to pass parameters to procedures?
What to do if dba lost the system password?
What is instant client oracle?
How many types of cluster table in Oracle?
What is a cursor in oracle?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
How to omit columns with default values in insert statement in oracle?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
What is meant by joins?
How to delete an existing row from a table in oracle?
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
Can we connect to ORACLE db using Windows Authentication?
What is a nvl function? How can it be used?