What is the string concatenation operator in oracle?

0 Answers  

---

Differentiate between function and procedure in oracle.

0 Answers  

---

What are the tools for Oracle ?

0 Answers   Infosys,

---

does Oracle has only one table space?

1 Answers   Oracle,

---

How to drop a stored procedure in oracle?

0 Answers  

---

What are the varoius components of physical database structure of oracle database?

0 Answers  

---

How to transfer database(500 gb) of oracle enterprise edition to standard edition downtime is only 1 hour not using exp/imp option ?

3 Answers   Digital Group,

---

What are joins..how many types of joins are there?

29 Answers   Amdocs, CSC, TCS,

---

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

1 Answers   IBM, Wipro,

---

1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?

2 Answers   Accenture,

---

What is currency type in database ?

3 Answers   TCS,

---

write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"

7 Answers   British Telecom BT,

---