Answer Posted / ela

Null is not eqal to zero not is an empty space. it is
simply comprising of 4 bytes of unknown value.

How to start your 10g xe server?

977

---

How to define an oracle sub procedure?

1070

---

Explain table?

1073

---

What is difference between sid and service name in oracle?

914

---

What is oracle join syntax?

954

---

What is meant by joins? List out the types of joins.

969

---

Can you tell me how to add new column in existing views?how?How is possible?

1384

---

How to install oracle odbc drivers?

1050

---

What is a data lock in oracle?

1036

---

How can we force the database to use the user specified rollback segment?

1087

---

What is the difference between hot backup and cold backup in oracle?

969

---

How to define an oracle cursor variable?

986

---

What is a partition in oracle?

1050

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

981

---

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2266

---