What is the difference between an Oracle Schema and an Oracle Instance?

3 Answers   IBM,

---

Difference between inner join vs where ?

0 Answers  

---

Which of the following is not a database object TABLESPACE TABLE INDEX NONE

1 Answers  

---

Is the After report trigger fired if the report execution fails ?

0 Answers   Oracle,

---

What is a sub query? Describe its types?

0 Answers  

---

acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account

2 Answers   Polaris,

---

Explain the use of constraints option in exp command.

0 Answers  

---

how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?

1 Answers   Infosys,

---

What is merge statement used for?

0 Answers  

---

What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?

1 Answers  

---

is there a tool to trace queries, like profiler for sql server?

0 Answers  

---

Explain the function of optimizer in oracle?

0 Answers  

---