write a query following data.
123.45 is input.write a query after decimal (ex:.45) load
into database ?how it possible?
- 3 Answers
- 6654 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
Assuming the column type to be decimal type and the same table to be updated, the string function can be used.
update dbname.tbname
set salary=
substr(cast (salary as char(10)),index(cast (salary as char(10)),'.'))
>>>salary is of type decimal..
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
If a Node is busy what are the steps you can take to avoid ?
In general, how do you optimze any sql in teradata?
What is spool space?
Explain the parallel data extension in teradata?
What is the command in bteq to check for session settings ?
What are the multiload utility limitations?
What is teradata? Also, list out some of the primary characteristics of teradata.
List out teradata data types?
What is meant by a dispatcher?
What happens in a conflict? How do you handle that?
What is a node in teradata? Explain
How to Extract data from multiple legacy systems?
What is the use of virtual processor connectivity in teradata?
How to eliminate product joins in a teradata sql query?
