Search the Community
Showing results for tags 'SQLdeveloper'.
Found 1 result
Hi! anyone with some oracle SQL experience? I want to join 2 tables, where the only possible join is by two different columns. Column A is a twelve character long number, while the other ( B ) is a two character long number. They can ba joined, because A is like .BB......... , So the 2. and 3. char is taken from B (and in no other cases this is possible). I think I should be able to use REGEXP_LIKE but how do I use column data in this function? '.column_name.........' isn't working naturaly. I tried to look around but I'm stuck now. The best would be if I can use the column name in the regex. I thought about manually entering the possible number combinations, but that wold require updates, and I can't allow that. Thank you for your time!