I have my update script:

UPDATE SCHEMA.TABLE_NAME
SET FLAG = 2
WHERE ID = 'UNIQUE_001'

What I need to do now, is try and get that query to run, with a SELECT statement at the beginning. SELECT needs to be the first six characters of my query.

I have tried

SELECT * FROM DUAL;
UPDATE SCHEMA.TABLE_NAME
SET FLAG = 2
WHERE ID = 'UNIQUE_001'

But dBeaver and my application points an error towards the TABLE_NAME not being found?

Has anyone got any other suggestions?