regular expression: numbers and letters allowed
How can i determine best way following: input string may contain only numbers and letters, letters can be from any alphabet.
Examples:
'123aBc' - correct, only numbers and letters
'123 aBc' - wrong, contains space
'123,aBc' - wrong, contains comma
'öäüõ' - correct, contains letters from Estonian alphabet.
'abc' - correct, contains letters from english alphabet.
I think i should use function "regexp_like" for that, because LIKE-operator can't do such things, correct?
How i should write the regular expression then? I'm new to reg expressions.