hello,
tell me the function which removes spaces from decimal
field?
Answers were Sorted based on User's Feedback
Answer / murali udayagiri
Generally the decimal field does't contain any spaces.
The below two are string functions.
1.decimal_lpad
2.decimal_strip
These can be used for
a)trim the spaces
b)Removing nondecimal
from string inputs.
Thanks,
Murali Udayagiri
| Is This Answer Correct ? | 2 Yes | 1 No |
what is difference between fuse and join? Explain in detail? In which scenario we will use them?
What are the benefits of data processing according to you?
What is the best way of creating huge test feeds?
What is a partition?
What is the difference between partitioning with key / hash and round robin?
What are the features of ab initio?
What is .abinitiorc and What it contain?
What are the differences between informatica and abinitio?
State the relation between EME, GDE and Co-operating system?
Hi friends if u don't mind i want one question What abt READ MULTIFILE COMPONENT? PLZ GIVE BRIEFLY?
Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?
I had 10,000 records r there i loded today 4000 records, i need load to 4001 - 10,000 next day how is in Type 1 and how is it on type 2?