What are hotfixes and patches?

0 Answers  

---

What is the process of debugging?

0 Answers  

---

Mention what are different methods to trace the pl/sql code?

0 Answers  

---

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

---

Explain the types of joins in sql?

0 Answers  

---

How do you get column names only for a table (sql server)?

0 Answers  

---

if a string is there like s1,s2,s3,s4.How to find count of commas in this.

4 Answers  

---

What is the difference between execution of triggers and stored procedures?

0 Answers  

---

Define concurrency control. : Transact sql

0 Answers  

---

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers  

---

What is the unique index?

0 Answers  

---

What are different types of sql commands?

0 Answers  

---