Answer / Shishu Pal Singh

"Rownum is a pseudocolumn in Oracle SQL that represents the sequential number of a row within its selected set (query result). It starts from 1 for each new query and resets when you use a different query."n

What is a sub query? Describe its types?

1 Answers  

---

What are the data types in oracle?

1 Answers  

---

Whether Oracle satisfy more codd rules or db2 satisfy more codd rules? How meny of each can satisfy ? Please answer me. Advance thanks

2 Answers   IBM,

---

What is Trace File ?

4 Answers   Thermotech,

---

Can we save images in a database and if yes, how?

1 Answers  

---

How to concatenate two text values in oracle?

1 Answers  

---

Briefly explain what is literal? Give an example where it can be used?

1 Answers  

---

How many types of table in Oracle?

1 Answers   MCN Solutions,

---

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1 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,

---

Give the different types of rollback segments.

1 Answers  

---

Explain index?

1 Answers  

---