Answer Posted / nageswararao.kamineni

we can create morethan one constrint on column
for example
create table emp11
(empno number(2) primary key,
ename varchar2(20) unique,not null
sal number(7,2));
here a table can containe only one primary key,if we wnat
declare more then one primary key,we can create like this
using unique and not null constarint.

How do I spool in oracle?

939

---

How to commit the current transaction in oracle?

1043

---

How to define an oracle cursor variable?

973

---

What is a named program unit?

1019

---

What is a nested table and how is it different from a normal table?

986

---

How to do paging with oracle?

949

---

What is meant by joins? List out the types of joins.

957

---

How to assign data of the deleted row to variables?

1013

---

What is the difference between 10g OEM and 11g OEM?

916

---

Give the different types of rollback segments.

978

---

How to use group functions in the select clause using oracle?

1023

---

Is oracle a language?

897

---

What is instant client oracle?

972

---

Why do we need integrity constraints in a database?

971

---

What are the parameters that we can pass through a stored procedure?

997

---