Answer / prativa mishra

begin
execute immediate('alter table table_name add constraint constraint_name primary key(column_name)');
end;

Answer / prativa mishra

BEGIN
EXECUTE IMMEDIATE 'ALTER TABLE TABLE_NAME ADD CONSTRAINT PK1
PRIMARY KEY(COLUMN_NAME)';
END;

Answer / saran

alter <tablename> attributename,constriantname

What is using in sql?

0 Answers  

---

What is a variable in sql?

0 Answers  

---

What is %s in sql?

0 Answers  

---

Can we enter data in a table in design view?

0 Answers  

---

how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,

---

What is inner join in sql?

0 Answers  

---

What is difference between joins and union?

0 Answers  

---

Explain the purpose of %type and %rowtype data types?

0 Answers  

---

What are sql functions? Describe the different types of sql functions?

0 Answers  

---

What is the largest value that can be stored in a byte data field?

0 Answers  

---

I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...

3 Answers  

---

What is differance unique key and primary key.

7 Answers   EDS,

---