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  

---

TABLE A TABLE B EMPNO ENAME EMPNO ENAME 1 A 1 A 2 B 2 B 3 C 3 C 4 D 4 D 5 E 5 E 6 F 7 G HOW TO GET THE UNMATCHED RECORDS IN SQL QUERY?

10 Answers   Satyam,

---

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

0 Answers  

---

Can you have multiple SPs with the same name on a database?

6 Answers   CGI,

---

What are sql triggers used for?

0 Answers  

---

---

What is the primary key?

0 Answers  

---

What is crud diagram?

0 Answers  

---

1 SELECT a.field1, b.field2, c.field3, d.field4 2 FROM atable a, atable b, ctable c, dtable d 3 ? 4 ORDER BY 1 What is the minimum number of joins that must be specified on line 3 in the sample code above to properly link the tables? Notice that the table "atable" is aliased twice: once as "a" and once as "b." 1. One join 2. Two joins 3. Three joins 4. Four joins 5. Five joins

6 Answers   Sonata,

---

what are the non-standard sql commands supported by 'mysql'? : Sql dba

0 Answers  

---

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

0 Answers  

---

Can variables be used in sql statements?

0 Answers  

---

How do I view output in sql developer?

0 Answers  

---