Answer Posted / guest

Index is an Oracle SQL object which we create to speed up
the query performance.
It is created automatically on those columns which contains
primary key or unique key.
We can also create the index manually by using create index
command.
Max 16 indexes can be defined per table.

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1786

---

How to define a record variable to store a table row?

1058

---

How to create a new table by selecting rows from another table?

1102

---

Give the advantages and disadvantages of clusters.

1050

---

Will you be able to store pictures in the database?explain.

992

---

How to load a large xml file?

1055

---

what is meant by magic query

2186

---

What are the data types in oracle?

1040

---

What privilege is needed for a user to connect to oracle server?

994

---

What is a snapshot in oracle database?

1025

---

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1115

---

What is oracle datasource?

985

---

How do I connect to oracle?

1030

---

What language does oracle use?

1100

---

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

1999

---