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 can we view last record added to a table?

1017

---

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2376

---

What is Reduced List of Values?

2146

---

How to start instance with a minimal initialization parameter file?

1022

---

How to convert character types to numeric types?

1096

---

In which language oracle has been developed?

1051

---

How to get a list of all user accounts in the database?

1067

---

How to check the oracle tns settings?

1026

---

Can we create database in oracle using command line ?

1058

---

What is logical backup in oracle?

997

---

How can you use check constraints for self referential integrity?

947

---

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.

1982

---

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

1715

---

How to empty your oracle recycle bin?

1011

---

Please explain oracle left join with an example?

1016

---