hello,
tell me the function which removes spaces from decimal
field?
Answer Posted / 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 |
Post New Answer View All Answers
Tell us about the architecture of abinitio.
What does edp stand for?
Difference between output_index and output_indexes in reformat
Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?
What is the purpose of having stored procedures in a data-based?
What would be the next step after collecting the data?
How can you import XML repositories exported from different tools like ODI
Pdl with an example?
What is the core of co> operating system?
How to replace last 4 digits of an input column with XXXX given input column has 12 digits?
Explain about ab initio’s dependency analysis?
How you can run a graph infinitely in ab initio?
What is a look-up?
When we should use 'jobid' for commit table (Output table component??
can we perform checkin and checkout through sandbox?