Answer Posted / rajesh

Mainly Two type of Index in Oracle.
1:-> Logical
2:-> Physical

1:-> Unique,Non Unique,Function
2:-> B-Tree & Bitmap

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1955

---

How to write a query with a left outer join in oracle?

1002

---

What is meant by recursive hints in oracle?

1026

---

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2127

---

Can we store images in oracle database?

944

---

Please explain oracle data types with examples?

990

---

Write a trigger example in oracle?

980

---

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

1626

---

Design database draw er diagram for a certain scenario ?

4528

---

What is a data dictionary and how can it be created?

1055

---

How to use subqueries in the from clause in oracle?

1043

---

How can we view last record added to a table?

970

---

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

---

What are the execution control statements in oracle?

1024

---

How to rollback the current transaction in oracle?

983

---