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 to execute a stored program unit?

1074

---

Why cursor variables are easier to use than cursors?

1094

---

How much memory your 10g xe server is using?

1103

---

Explain the use of record length option in exp command.

1067

---

how to make an oracle object

2359

---

Why oracle is used?

1054

---

IS it possible to built the oracle database without setting the kernal parameters?

2347

---

What are the advantages of oracle?

1028

---

What happens in oracle commit?

1024

---

What is a table index in oracle?

1131

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4366

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1846

---

How to use fetch statement in a loop?

1019

---

How to start a new transaction in oracle?

1087

---

What is the exact use of Collections?

2143

---