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

What is analyze command used for?

1016

---

How to install oracle odbc drivers?

1046

---

How to build data dictionary view an new database?

968

---

What happens if you lost a data file?

987

---

What is an anonymous block?

1170

---

How to define a cusotmer as a supplier in ORACLE R12

2184

---

What is columnar storage what is the advantage?

996

---

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

927

---

Explain joins in oracle?

987

---

How to drop a tablespace?

995

---

How to compare dates in oracle sql?

1056

---

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

1676

---

How to import one table back from a dump file?

979

---

What is a cursor variable?

1055

---

Does facebook use oracle?

990

---