write a query following data.
123.45 is input.write a query after decimal (ex:.45) load
into database ?how it possible?
- 3 Answers
- 7273 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
Define views in teradata with syntax.
What is the maximum number of dml can be coded in a multiload script?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
How many tables can you join in v2r5?
Describe the between keyword in teradata?
Highlight all the modes that are present under Confidence Level.
What are the steps involved in the process flow of the sql statement through channel attached system?
How do you determine the number of sessions?
What is the use of stored procedures in teradata?
Which is faster fastload or multiload?
What is meant by a Highest Cost Plan?
Explain fastload in teradata?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
Explain Teradata performance tuning and optimization?
What is the difference between teradata and oracle?
