Answer / yuvaevergreen

dynamic sql is invoking SQL inside a stored procedure during
run time. execute immediate or call can be used to invoke
dynamic sql.

I Have Name field in a Table Name ------------- abcde;fgh;ijk; abc;def;jklm;no I want to write a sql to display name field data with out ';'.so i want to replace ; with '' how will write in Teradata

3 Answers   Wipro,

---

why varchar takes 2 extra bytes?

4 Answers   IBM,

---

What are the main components of teradata system?

0 Answers  

---

Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?

4 Answers  

---

What are the frequently used data types in teradata?

0 Answers  

---

Explain how spool space is used.

0 Answers  

---

what is the default character set in teradata,,?

2 Answers   IBM, TCS,

---

what is a multi statement request in TD? what is the diif b/w V2R5 & TD12? what is the diff b/w MACRO & STORED PROCEDURE?

3 Answers   HCL,

---

What is the use of virtual processor connectivity in teradata?

0 Answers  

---

Explain teradata architecture in detail with a diagram.

0 Answers  

---

Explain the most common data types used in teradata?

0 Answers  

---

Mention a few of the ETL tools that come under Teradata.

0 Answers  

---