Answer Posted / hima bindu

Hi
If u want to import the data which is in .xls file to
oracle data base then first create temporary table in
database then write insert statements in excel file using
functions then execute that scripts into toad. Then the
data in excel sheet is imported to data base.

Give the advantages and disadvantages of clusters.

996

---

What is where clause in oracle?

980

---

What is a cursor in oracle?

1106

---

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1045

---

How to list all tables in your schema?

989

---

What to do if the binary spfile is wrong for the default instance?

998

---

Can we connect to ORACLE db using Windows Authentication?

1180

---

How to assign a table row to a record variable?

965

---

What is data type in oracle?

1039

---

How to execute the package in oracle?

1036

---

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

1978

---

How to export data to a csv file?

1200

---

What are the oracle differences between nvl and coalesce

1065

---

What privilege is needed for a user to delete rows from tables in another schema?

1018

---

What is Redo Log Buffer in Oracle?

1121

---