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 is the difference between primary key and unique key and foreign key in oracle?

918

---

What are the different types of modules in oracle forms?

951

---

What is an oracle user account?

930

---

What to do if the binary spfile is wrong for the default instance?

998

---

How to get a list of all background sessions in the database?

943

---

Is oracle a relational database?

870

---

How different is ms access and oracle?

987

---

How to check database size in Oracle?

1115

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1617

---

How do I connect to oracle?

974

---

How many categories of data types?

937

---

How do I manually uninstall oracle client?

1024

---

How to update a table row with a record?

960

---

How to do a full database export?

1044

---

What is the purpose of save points in oracle database?

1004

---