Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8595 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / nitin bansal
You can use TRANSLATE function.
select translate(Name,'',';') as Name
from tablename;
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How do you determine the number of sessions?
What is logical data model?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What does Amp contain and what are all the operations that it performs?
Explain PDE.
How is MLOAD Client System restarted after execution?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What are the different table types supported by teradata?
why use references rather than pointers in the public api, particularly for arguments which are modified?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
How do you verify a complicated sql?
What is teradata? Also, list out some of the primary characteristics of teradata.
What is the primary index in teradata?
Explain Teradata performance tuning and optimization?
What are the scenarios in which full table scans occurs?
