What are the limitations oracle database 10g xe?

0 Answers  

---

Explain a private synonyms?

0 Answers  

---

How to grant create session privilege to a user in oracle?

0 Answers  

---

Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15

2 Answers  

---

Explain the difference between sap and oracle?

0 Answers  

---

cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..

2 Answers  

---

How to check database size in Oracle?

0 Answers   MCN Solutions,

---

What happens to the current transaction if a ddl statement is executed?

0 Answers  

---

Explain the difference between replace() and translate() functions in oracle?

0 Answers  

---

Please explain oracle left join with an example?

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,

---

Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.

2 Answers  

---