In the below code I'm trying to get all tables.columns in my schema that have a column name of B01 or B02. That works fine, BUT I'm trying to filter out any tables that begin with 'INT', and when I include the commented-out line it throws an 'ORA-00904: "LEFT": invalid identifier' error message.
Question: What's the correct syntax for the commented-out line below?
SELECT column_name, table_name
WHERE owner = 'JHORN_SANDBOX'
AND olumn_name IN ('B01', 'B02')
-- AND LEFT(table_name, 3) != 'INT' -- <-- This line is not working..
ORDER BY column_name, table_name;
Thanks in advance.