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.

What is the order of defining local variables and sub procedures/functions?

1018

---

What is a proxy class?

982

---

How to list all tables in your schema?

999

---

How to run queries on external tables?

998

---

What is connection pooling in oracle?

922

---

ABOUT IDENTITY?

2014

---

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1950

---

Can a formula column referred to columns in higher group ?

2470

---

How to create a new table in oracle?

1086

---

How to update values on multiple rows in oracle?

989

---

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2010

---

What is save point in oracle database?

1255

---

Explain oracle data types with examples?

974

---

Explain index?

1213

---

What is oracle data type?

914

---