Difference between inner join vs where ?

0 Answers  

---

Can Multiple instances be run on Single Machine???

3 Answers  

---

Can u make a synonym for deptno=10 only from emp table.

1 Answers   TCS,

---

What does ROLLBACK do ?

1 Answers  

---

How does Oracle guarantee data integrity of data changes?

0 Answers  

---

---

How to use regular expression in pattern match conditions in oracle?

0 Answers  

---

5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.

3 Answers   Wipro,

---

What do you mean by a tablespace?

0 Answers  

---

i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.

1 Answers   MasterCard,

---

you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??

2 Answers   BirlaSoft,

---

What is mean by Program Global Area (PGA) ?

9 Answers   Bajaj,

---

How to run queries on external tables?

0 Answers  

---