i have a word ***********hello********world******. I require a o/p **********hello world**********, Need to delete the middle stars.

3 Answers  

---

What is varchar used for?

0 Answers  

---

Can we create non-clustured index on a clustered index ?

4 Answers   TCS,

---

What is a data manipulation language?

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 pivot query?

0 Answers  

---

What is cursor explain with example?

0 Answers  

---

How long it takes to learn pl sql?

0 Answers  

---

How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')

2 Answers  

---

Can there be more than one function with a similar name in a pl/sql block?

0 Answers  

---

What is full join?

0 Answers  

---

what is the difference between join and union? : Sql dba

0 Answers  

---