write a query following data.
123.45 is input.write a query after decimal (ex:.45) load
into database ?how it possible?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ankal
assuming this value is sal colume i mean sal=123.45; u want to update it with after decimal value.i think The following query try.
update table_name set sal=sal-cast(sal as int));
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / tdguy
Above answers are correct, but data type should be taken
care of.
Is This Answer Correct ? | 1 Yes | 0 No |
What are teradata utilities?
What is the use of virtual processor connectivity in teradata?
Hash collision?
How to identify ppi columns?
What is the difference between teradata and oracle?
What are some commonly used bteq scripts?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What is meant by MATCHTAG in multiload utility?
what is object level locking ? where do appear this type of locking ?
What are the 5 phases in a multiload utility?
Can some one tell me the ressolution for the error. I was not able to answer this question in wipro interview. "The transaction exceeded the maximum number of rowhash locks allowed"
what is use of fload loading into set table?