Toad World® Forums

Help with selecting only certain values


#1

Hi,

Can someone please tell me how I can select only objects from dba_objects view whose last character is a number, i.e. 0-9?

For example, I would like to select an object_named “EMPLOYEES555” but not the one named “EMPLOYEES”.

Thank you.