Does Oracle support a wildcard operator?
I'd like to issue the command:
TRUNCATE TABLE TEST_PRE_*
and have Oracle truncate all tables that begin with TEST_PRE_
When I try to execute this statement, I get the error "SQL command not properly ended" Is there a way to make this work?