Answer / Abhay Kumar Pandey

To bring a tablespace online in Oracle Database, you can use the following SQL command: ALTER TABLESPACE <tablespace_name> ONLINE; Replace <tablespace_name> with the name of your tablespace.

What are the roles of dba?

1 Answers  

---

what's query optimization and without use of IN AND Exist can we get another way data from query

1 Answers  

---

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1 Answers  

---

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

1 Answers   Cisco,

---

how to use sequence and what use of sequence cache

1 Answers  

---

What is Database Link ?

2 Answers  

---

State the difference between a primary key and foreign key?

1 Answers  

---

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

1 Answers  

---

What is the order of defining local variables and sub procedures/functions?

1 Answers  

---

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

2 Answers   IBM,

---

What are the different types of trigger and explain its various uses and functions?

1 Answers  

---

A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?

7 Answers   Cognizant, IBM,

---