Oracle LEFT string compare throws a 'ORA-00904: "LEFT": invalid identifier' error message.
Hi Guys
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_nameFROM all_tab_columnsWHERE 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;