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
- 7978 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
Why managing the data is important?
What do you mean by fastexport in teradata?
What can be achieved by using the teradata rdbms?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What is the syntax for case when statement?
What are the steps involved after the disk manager passes the request?
What is TPD?
Explain and compare pros and cons of start schemas?
Explain the most common data types used in teradata?
What are default access rights in teradata? What explicit right can be given to a user?
Explain fallback in teradata?
Describe the between keyword in teradata?
How is MLOAD Teradata Server restarted after execution?
What is meant by a Highest Cost Plan?
What is meant by a dispatcher?
