Answer / Jha Nileshkumar Kripanath

To load EBCDIC data using SQL*Loader, you need to set the NLS_CHARACTERSET parameter in your control file to 'WE8MSWIN1250' or any other appropriate EBCDIC character set. Additionally, ensure that your database character set is also set to EBCDIC.

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1 Answers  

---

What is mutating sql table?

1 Answers  

---

Can we update views in sql?

1 Answers  

---

What is cursor and why it is required?

1 Answers  

---

What are tuples in sql?

1 Answers  

---

Show code of a cursor for loop.

1 Answers  

---

What is a dirty read sql?

1 Answers  

---

What does fetching a cursor do?

1 Answers  

---

How collections are improve the performance?

1 Answers   Polaris,

---

What is anonymous block in sql?

1 Answers  

---

Which type of cursor is used to execute the dml statement?

1 Answers  

---

Can we join tables without foreign key?

1 Answers  

---