Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Tell us about the architecture of abinitio.

1143


What does edp stand for?

1214


Difference between output_index and output_indexes in reformat

1347


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?

1052


What is the purpose of having stored procedures in a data-based?

1171


What would be the next step after collecting the data?

1239


How can you import XML repositories exported from different tools like ODI

3598


Pdl with an example?

1154


What is the core of co> operating system?

1250


How to replace last 4 digits of an input column with XXXX given input column has 12 digits?

1133


Explain about ab initio’s dependency analysis?

1238


How you can run a graph infinitely in ab initio?

1651


What is a look-up?

1345


When we should use 'jobid' for commit table (Output table component??

9206


can we perform checkin and checkout through sandbox?

1222