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
Explain why we use partitioning the session in informatica?
Under what condition selecting sorted input in aggregator may fail the session?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Enlist some properties of sessions.
What is dimensional table?
What do think which one is the better joiner or look up?
What is meant by target load plan?
What is the scenario which compels informatica server to reject files?
Explain pushdown optimization and types in informatica
Which transformation is needed while using the Cobol sources as source definitions?
What are the different types of repositories created using informatica?
What are Dimensional table?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What do you understand by term role-playing dimension?
How many ways a relational source definition can be updated and what are they?