Answer / Mukesh Kumar Dixit

SELECT table1.*, table2.(column_from_table2) FROM table1 RIGHT OUTER JOIN table2 ON table1.key = table2.key WHERE table2.key IS NULL;

Tell me New Feature of Oracle 10g?

5 Answers   Thermotech,

---

What would you use to improve performance on an insert statement that places millions of rows into that table?

1 Answers  

---

What is data block in Oracle?

1 Answers   MCN Solutions,

---

Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

1 Answers  

---

Is there an oracle sql query that aggregates multiple rows into one row?

1 Answers  

---

How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?

2 Answers   Infosys,

---

How to run the anonymous block again?

1 Answers  

---

When do you get a .pll extension in oracle?

1 Answers  

---

How to start your 10g xe server?

1 Answers  

---

Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.

1 Answers  

---

How to create index-by table in oracle?

3 Answers  

---

What happens to the data files if a tablespace is dropped?

1 Answers  

---