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?

Answers were Sorted based on User's Feedback



hello, tell me the function which removes spaces from decimal field?..

Answer / prakash b

Use 'decimal_lpad' or 'decimal_strip'

Is This Answer Correct ?    16 Yes 1 No

hello, tell me the function which removes spaces from decimal field?..

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

Post New Answer

More Ab Initio Interview Questions

what is difference between fuse and join? Explain in detail? In which scenario we will use them?

1 Answers   IBM,


What are the benefits of data processing according to you?

0 Answers  


What is the best way of creating huge test feeds?

1 Answers  


What is a partition?

0 Answers  


What is the difference between partitioning with key / hash and round robin?

0 Answers  


What are the features of ab initio?

0 Answers  


What is .abinitiorc and What it contain?

3 Answers   CSC,


What are the differences between informatica and abinitio?

0 Answers  


State the relation between EME, GDE and Co-operating system?

0 Answers  


Hi friends if u don't mind i want one question What abt READ MULTIFILE COMPONENT? PLZ GIVE BRIEFLY?

2 Answers  


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)?

0 Answers  


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?

5 Answers   CTS, IBM,


Categories