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
- 6687 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 port in oracle? how is it related to database application.
How to create a single index for multiple columns?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
How to start an oracle instance?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
How will you differentiate between varchar & varchar2?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Explain oracle’s system global area (sga).
How to execute the package in oracle?
Why cursor variables are easier to use than cursors?
defination of bitmap index
What are the arithmetic operations?
How to create a stored program unit?
How to define a sub function?
Please explain oracle data types with examples?
