Answer / Dinesh Kumar Bhaskar

SQL*Loader treats newline characters as field terminators by default. If you have records with multiple lines, they will be treated as separate records. To change this behavior, you can use the FIELDS TERMINATED BY option in your control file to specify another character as a field separator.

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

1 Answers  

---

I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?

1 Answers  

---

what is self-join? : Sql dba

1 Answers  

---

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

1 Answers  

---

What are the attributes of SQL*PLUS ?

2 Answers   Dream Careers, Oracle,

---

what are all the different normalizations? : Sql dba

1 Answers  

---

How is use pl and sql?

1 Answers  

---

What is a sql select statement?

1 Answers  

---

What is a package ? What are the advantages of packages ?

2 Answers   Symphony,

---

How can check sql version from command line?

1 Answers  

---

What are different types of keys?

1 Answers  

---

What is the purpose of the primary key?

1 Answers  

---