Answer / kishore

Index is a performance tuning method of allowing faster
retrieval of records. Oracle indexing is a standing B-Tree
indexing for fast retrieval.

Syntax: CREATE INDEX EmpInfo ON Employee(EmpID,Emp_Name)

we have two types indexes

1. Clustered indexes
2. Non-Clustred indexes

Answer / ruchi

index is a data structure used for fast retrival of data.

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

0 Answers  

---

In my table i'm having the duplicate records with sequence number and my requirement is when in new record is coming i want to delete existing old record(onlyone i.e maintaing the partial duplicate date )and add new record

2 Answers   Syntel,

---

default triggers available for reports

0 Answers  

---

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

0 Answers  

---

i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

0 Answers   HCL,

---

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

0 Answers  

---

When a user process fails, what background process cleans up after it?

1 Answers  

---

How to clone the database using RMAN back

0 Answers  

---

i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value

6 Answers   IBM,

---

what is shared memory?

1 Answers   IBM,

---

1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

0 Answers   Cap Gemini,

---

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

0 Answers  

---