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.

What privilege is needed for a user to query tables in another schema?

964

---

Can we use bind variables in oracle stored procedure?

941

---

Why is oracle database so popular?

986

---

What is a proxy object?

1049

---

How to pass parameters to procedures in oracle?

1032

---

List the types of joins used in writing subqueries?

986

---

How to get execution path reports on query statements?

974

---

What are the different editions of oracle?

1100

---

How to convert numbers to characters in oracle?

1025

---

How to export several tables together?

1045

---

When system tablespace is created?

1028

---

How to see the table columns used in an index?

1013

---

Please explain drop constraint oracle?

1087

---

How to create an oracle database?

1026

---

What is oracle in java?

958

---