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
- 8128 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
Is multi insert ansi standard?
What is a level of granularity of a fact table?
What are the frequently used data types in teradata?
Highlight the differences between Primary Key and Primary Index.
What do you mean by caching in teradata?
what is object level locking ? where do appear this type of locking ?
What is upsert statement in teradata?
What are the 5 phases in a multiload utility?
What tools would you use for that?
Discuss the advantages of using partitioned primary index in a query?
What do you mean by ttu in teradata?
What do you mean by fastexport in teradata?
While creating table my dba has fallback or no fallback in his ddl. What is that?
How do you verify a complicated sql?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
