Answer Posted / vinoth

ALTER TABLE EMP ADD CONSTRAINT EMP_PK PRIMARY KEY(EMPNO)
DISABLE;

Primary key constraint is created and no index is created
since the constraint is disabled initially.

What is sap sql?

532

---

How to use sql*plus built-in timers?

574

---

Does oracle roll back the transaction on an error?

529

---

how to analyze tables with 'mysqlcheck'? : Sql dba

541

---

What is the difference between join and natural join?

471

---

---

Is pl sql and postgresql same?

564

---

What is the left table in sql?

515

---

What is trigger types of trigger?

548

---

How can we implement rollback or commit statement in a trigger?

574

---

what is a composite primary key ? : Sql dba

576

---

How do you update a value in sql?

545

---

what is the syntax for using sql_variant_property? : Transact sql

528

---

how to shutdown mysql server? : Sql dba

563

---

Is hadoop a nosql?

570

---

Describe different types of general function used in sql?

530

---