Avatar of Jim Horn
Jim Horn
Flag for United States of America

asked on 

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_name
FROM    all_tab_columns
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;

Open in new window


Thanks in advance.
Jim
Oracle Database

Avatar of undefined
Last Comment
slightwv (䄆 Netminder)

8/22/2022 - Mon