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 to best split csv strings in oracle 9i?

984

---

How to start a new transaction in oracle?

1015

---

How to lock and unlock a user account in oracle?

1025

---

How to display employee records who gets more salary than the average salary in the department?

998

---

Explain the function of optimizer in oracle?

1053

---

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2002

---

How do you bind variables in oracle?

928

---

What is an oracle wallet?

880

---

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1006

---

How to drop a tablespace?

982

---

Explain the truncate in oracle?

909

---

Explain the features of oracle?

989

---

How to bring a tablespace offline?

998

---

Does facebook use oracle?

979

---

What is a schema in oracle?

965

---