how to check if a table exists
385345Jan 13 2003 — edited Jan 19 2004Hi, I am new in Oracle dba area. I am writing a trigger that writes a message into a table(B) if there are changes made in another table(A). It's simple. But first I need to check if table(B) exists, if not create and then write a message. I couldnt find anything related to how to check if a certain table exists. If anybody knows, please give me a hint. thanks