Answer / Yogesh Singh Garbyal

To insert or use a single quote within an Oracle SQL string, you should escape it by doubling the single quotes ('''). For example, if you want to insert 'O'Connor', you can do: `INSERT INTO EMPLOYEES VALUES ('''O'Connor''')`

diff between DELETE and TRUNCATE?.

14 Answers   HCL, Yalamanchili Software,

---

Difference between sub query and nested query ?

19 Answers   Keane India Ltd, TCS,

---

how to delete all duplicate records from a table using subquery?

7 Answers   ABC, Cap Gemini,

---

How to use "while" statements in oracle?

1 Answers  

---

What is coalesce function?

1 Answers  

---

What is Virtual Private Database in Oracle?

1 Answers   MCN Solutions,

---

How to save query output to a local file?

1 Answers  

---

Explain can a view based on another view?

1 Answers  

---

i have a table with the columns below as Emp_ID Address_ID Address_Line City Country -------- --------- ----------- ------ --------- Q: Display the Emp_ID's those having more than one Address_ID

7 Answers   IBM,

---

What are the advantages of Views ?

3 Answers  

---

how to find full database size

1 Answers   BirlaSoft, Consultancy,

---

If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X

2 Answers  

---