For those who may not have seen it, the @test_script query looks like this:
with
upper_names as (
select employee_id, upper(last_name) as upper_last_name
from hr.employees ),
string_match as (
select employee_id, upper_last_name,
instr( upper_last_name, 'KIN', 1, 1 ) as instring_match
from upper_names )
select employee_id, upper_last_name
from string_match
where instring_match > 0;
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
