Answer / guest

select * from t1 full outer join t2

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

0 Answers   Infosys,

---

how will I find the first 5 highest salaried employees in each dept in oracle.

22 Answers   IBM,

---

State any two functions of oracle?

0 Answers   Aricent,

---

can anyody please send me the dump for Oracle 10g certifications for DBA path?

0 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

0 Answers   Cisco,

---

what is the use of system.effective.date variable in oracle?

0 Answers  

---

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

0 Answers  

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

---

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

0 Answers  

---

What are joins, explain all types of joins?

0 Answers   Bravura Solutions,

---

What is a trigger oracle?

0 Answers  

---

Why cursor variables are easier to use than cursors?

0 Answers  

---