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,

---

How to Remove the 3rd highest salary person record from table?

9 Answers   HCL, IBM,

---

4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>

1 Answers   Wipro,

---

how do u know the total no of rows in a table?

6 Answers  

---

What is forall Statement ?

2 Answers   Thermotech,

---

---

Differentiate between TRUNCATE and DELETE?

2 Answers  

---

Please explain oracle data types with examples?

0 Answers  

---

Whats the benefit of dbms_stats over analyze?

0 Answers  

---

How to find out what privileges a user currently has in oracle?

1 Answers  

---

What to do if dba lost the system password?

0 Answers  

---

Do you know about aggregate functions? What is row num function? Can it be used all databases?

1 Answers   Bravura Solutions, Cap Gemini,

---

How to insert multiple rows with one insert statement in oracle?

0 Answers  

---