Answer Posted / prativa mishra

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

How do you use collections in procedure to return the resultset?

2181

---

What is an emotional trigger?

930

---

How to select unique records from a table?

999

---

How do you update sql?

913

---

How do I find duplicates in two columns?

1057

---

how to load data files into tables with 'mysqlimport'? : Sql dba

1032

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1058

---

how to drop an existing view in mysql? : Sql dba

995

---

What is a recursive stored procedure?

1096

---

What is integrity in sql?

979

---

What is the purpose of cursors in pl/sql?

1078

---

What can I use instead of union in sql?

903

---

What are the string functions in sql?

923

---

how to escape special characters in sql statements? : Sql dba

967

---

Does sql backup shrink transaction log?

914

---