Answer Posted / rajan sharma

Column level are those constraints that are inserted after
the declaration of the data typeot

Syntax :

CREATE TABLE table_name
(Column_name Datatype NOT NULL )

Example : Not null,pimary key,foreign key, unique and check.

Table level constraints are those that are inserted at the
end of the table.

Example : pimary key,foreign key, unique and check.

Thanks

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

1819

---

What is dual table oracle?

520

---

How to drop an index in oracle?

596

---

How to install oracle database 10g xe?

558

---

What is redo log?

617

---

---

How to lock and unlock a user account in oracle?

608

---

How to run create database statement again?

615

---

How to drop a stored procedure in oracle?

584

---

What is logical backup in oracle?

570

---

How to create a stored program unit?

570

---

What do you mean by merge in oracle and how can you merge two tables?

515

---

What is the difference between sharding and partitioning?

495

---

What is save point in oracle database?

721

---

Design database draw er diagram for a certain scenario ?

4095

---

how to do daily transactions with out sql* loader control file regesterd in apps?

1216

---