Answer Posted / nazim

select convert(char(12),getdate(),106)

Can objects of the same schema reside in different tablespace?

1046

---

What is meant by raw datatype?

1046

---

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

1010

---

What are the different types of database objects?

1042

---

List out the components of logical database structure of oracle database.

1011

---

What is tns entry?

1111

---

What are privileges and grants?

1049

---

What are the four Oracle system processes that must always be up and running for the database to be useable?

993

---

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

987

---

How to define an anonymous procedure with variables?

1127

---

How to set up autotrace for a user account?

1033

---

How to create a table index in oracle?

1114

---

How to get a list of all background sessions in the database?

972

---

Explain the use of rows option in imp command.

1071

---

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

2306

---