State all possible different index configurations a table can possibly have?

0 Answers  

---

What are set operators?

0 Answers  

---

acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account

2 Answers   Polaris,

---

How will you identify oracle database software release?

0 Answers  

---

how to do daily transactions with out sql* loader control file regesterd in apps?

0 Answers   Arrow Electronics,

---

can u plz provide me oca sql dumps please i need them

0 Answers  

---

WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.

3 Answers  

---

write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"

7 Answers   British Telecom BT,

---

What is oracle rownum?

0 Answers  

---

How to get maxsal , minsal, ename department wise in single query

0 Answers  

---

hai, when to use char and varchar2....?

2 Answers  

---

What are the Limitations of a CHECK Constraint ?

5 Answers  

---