Answer Posted / dhara

-> It is one of the most important concepts in the study of
the RDBMS.
->Tables that are hugged and bilky often defeat the purpose
of having an RDBMS all togather. This is because such
tables may not be easy to maintain.
->There are two ways of approching logical database design-
the top down approch
the botton up approch

What is the difference between truncate & delete command?

1125

---

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2205

---

How to filter out duplications in the returning rows using oracle?

989

---

How to invoke the data pump export utility?

1117

---

How can we find out the duplicate values in an oracle table?

996

---

How many categories of data types in oracle?

962

---

how may join possible between (requisition with purchase order)

2170

---

What is a parameter file in oracle?

1051

---

Define oracle database

993

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1617

---

Respected sir, Please send me technical questions related to oracle apps..

1762

---

What do you mean by a tablespace?

980

---

What is ASM (Automatic Storage Management) in Oracle?

1124

---

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2902

---

In what script is snap$ created? In what script is the scott/tiger schema created?

2656

---