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
- 6553 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
How to load excel data sheet to oracle database
Difference between hot backup vs. Cold backup?
Query to retrieve record for a many to many relationship ?
What is java oracle used for?
master table and child table performances and comparisons in Oracle ?
How to sort the query output in oracle?
what is reindexing?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
What is the difference between count (*), count (expression), count (distinct expression)?
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
What is save point in oracle database?
How to use an explicit cursor without open statements?
How to create a stored procedure in oracle?
What happens to the current transaction if a ddl statement is executed?
How to pass a parameter to a cursor in oracle?
