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
- 6684 Views
- I also Faced
- E-Mail Answers
Answer Posted / manvendra
ALTER TABLE TABLE_NAME
MODIFY COLUMN (COLUMN2 PRIMARY KEY);
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
How to rename a tablespace in oracle?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What are the differences between date and timestamp in oracle?
How many file formats are supported to export data?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How to list all indexes in your schema?
What are group functions in oracle?
How to start a new transaction in oracle?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What is the fastest query method to fetch data from the table?
What are the oracle built-in data types?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
How to create a new table in oracle?
How to define an anonymous procedure with variables?
What is the relationship among database, tablespace and data file?
