Answer Posted / akki

column constraint is only for particular column to provide restriction,

where in table level constraint we define multiple constraint at same time except not null .

not null is only used for column level.

ex: create table customer(cust_id number(2) not null,cust_name varchar2(20)check(cust_name like 'C%');

above example is shows constraints on column level.

How do we get field details of a table?

730

---

What is the difference between primary key and unique key and foreign key in oracle?

760

---

What is a cognitive schema?

699

---

How to experiment a data lock in oracle?

791

---

How to install oracle database 10g xe?

775

---

How to insert a new row into a table in oracle?

822

---

When do you get a .pll extension in oracle?

910

---

Can we store images in oracle database?

747

---

how do u setup a replication site?

1702

---

Explain what are clusters?

841

---

Can we create trigger on materialized view in oracle?

766

---

Can we use bind variables in oracle stored procedure?

690

---

How to upsert (update or insert into a table)?

743

---

What are the different types of failures that occur in Oracle database?

832

---

What are the system predefined user roles?

784

---