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 |
Have you ever encountered an error called “depth not equal”?
Why creation of temporary files depends on the value of MAX CORE
what is macro?At what situation we have to face?
Can sorting and storing be done through single software or you need different for these approaches?
Can you explain data flow graph with an example?
What will be the skew for, input file->partition by key-> partition by round robin->output file
When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?
What is the difference between partitioning with key and round robin?
How to replace last 4 digits of an input column with XXXX given input column has 12 digits?
Explain data flow graph with an example?
What are the benefits of data processing according to you?
How can you achieve scan using reformat ?