Interested to Buy Any Domain ? << Click Here >> for more details...
Please help me how to write a Query to change the primary
key constraint from 1 attribute to another attribute in a
table
- 3 Answers
- 6397 Views
- I also Faced
- E-Mail Answers
Answer Posted / chandana
YOU CANNOT CHANGE THE CONSTRAINTS DIRECTLY ON A COLUMN.
FIRST DROP THE CONSTARINT U HAVE CREATED AND THEN USE ALTER
COMMAND TO ADD CONSTARINT TO THE CORRECT COLUMN.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
What is the oracle implicit cursor?
How to convert characters to dates in oracle?
What privilege is needed for a user to create tables in oracle?
How to install oracle odbc drivers?
How to install oracle database 10g xe?
What is a lookup table in oracle?
How do we represent comments in oracle?
How to connect to the server with user account: sys?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
How to use "if" statements on multiple conditions?
Please explain drop constraint oracle?
why dont we assign not null constraint as table level constraint.
What are the different pseudo commands? Explain in general?
How to view the data files in the current database?
