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...

How will restrict values in 0-9 and A-Z and a-z and special
character.Only allowed these chars otherwise we will reject
the records? what is the function we used to restrict...

Answer Posted / abhishek

REGEXP_LIKE(COL_NAME,'[[:alphanum:]]')

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What the difference is between a database, a data warehouse and a data mart?

1202


What are junk dimensions?

1114


server hot-ws270 is connect to Repository B. What does it mean?

2654


What is the maplet?

1205


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7503


What is meant by lookup transformation?

1183


What is the use of transformation?

1057


How to create a non-reusable instance of reusable transformations?

1171


How do you use reject loader.

2651


what is the size of u r source(like file or table)?

2310


What is union transformation?

1017


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2371


What is complex mapping?

1171


How would you copy the content of one repository to another repository?

1059


What is source qualifier transformation in informatica?

1066