Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 207482 Views
- Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions, I also Faced
- E-Mail Answers
Answer Posted / umapathy.r
The column holding the primary key constraint cannot accept
null values.whereas colum holding the unique constraint can
accept null values assume that t3 is a table with two
columns t1 having primary key constraint and t2 having
unique constraint if u try to insert null into t2 it will
accept that values whereas column t1 will not accept null
| Is This Answer Correct ? | 1164 Yes | 121 No |
Post New Answer View All Answers
What are internal user account in oracle?
What are the different types of modules in oracle forms?
What is partitioned table in Oracle?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Explain the blob datatype?
What is the order of defining local variables and sub procedures/functions?
Give syntax for SQL and ORACLE joins.
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What privilege is needed for a user to create indexes in oracle?
What is a nested table and how is it different from a normal table?
How to get execution statistics reports on query statements?
What is a sub query and what are the different types of subqueries?
How many memory layers are in the oracle shared pool?
What are the differences between lov and list item?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
