Interested to Buy Any Domain ? << Click Here >> for more details...
write a query following data.
123.45 is input.write a query after decimal (ex:.45) load
into database ?how it possible?
- 3 Answers
- 7833 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
What are differences between teradata and ansi session modes in teradata?
Syntax for case when statement?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What are the functions of a teradata dba?
What are some primary characteristics of teradata?
How to Extract data from multiple legacy systems?
What tools would you use for that?
what are the day to day activities of teradata DBA ?
How to run a query in teradata?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
How do you see a ddl for an existing table?
What is the difference between global temporary tables and volatile temporary tables?
What is database exceptions in teradata?
What is the difference between teradata and basic rdbms?
What are the different softwares used with their functions in teradata?
