Answer Posted / gurupatham

Column Level Constraints refers Only One Column .Which does
not have the column name at declaration time .
Ex : Create table emp
( empno number primary Key,
--,
--);

Table Level constraints refers one or more than one column .
Which does have column name at declaration time.
Ex: Create table emp
( empno number ,
--,
--,
Constraints pk_con primary Key(empno));

All constraints can be created as Column and Table level
expect Not Null constraints .
Not Null constraints can only be created as column level
constraints . Does not have constraints name.

How to define and use table alias names in oracle?

505

---

How to do clean up if create database failed?

563

---

Can we call procedure inside function in oracle?

598

---

How to define a sub function?

658

---

Difference between inner join vs where ?

599

---

---

What happens to indexes if you drop a table?

686

---

Can you create a synonym without having a table?

543

---

Why is oracle so popular?

556

---

What is primefaces used for?

550

---

Give the constructs of a package, function or a procedure.

529

---

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

1925

---

Define oracle database

588

---

What are the common oracle dba tasks?

617

---

Explain the difference between a procedure and a function?

549

---

What are temporal data types in oracle?

587

---