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 / babu
Hi,
As per my knowledje,i find below method for u r query.
select * from tab where col1 between 'A' and 'Z' or col1
between 'a' and 'z' or col1 between '0' and '9'
please let me know,if u have any concerns.
Babu
Is This Answer Correct ? | 5 Yes | 8 No |
Post New Answer View All Answers
Define Pmrep command?
Mention few advantages of router transformation over filter transformation.
What do you understand by SOA of Informatica?
Enlist the tasks for which source qualifier transformation is used.
What are active transformations.
What is meant by query override?
What do you mean by worklet?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is enterprise data warehousing?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
How to load a Dimension ? and how to load a fact table?
What is the difference between a connected look up and unconnected lookup?
tell me about your project functionality
What is parallel processing in informatica?
What is the maplet?