Wild-card charcters in SQL statement
536473Dec 18 2006 — edited Dec 18 2006Is there any way where I can display only table starts with 'T' charaters along with maximum three digits. i.e. table names T12, T121, T454,T5 etc.
I tried using wild card charcters 'T???'. But, it does not display any rows.
SELECT SUBSTR(F.FILE_NAME,1,35),SUBSTR(F.TABLESPACE_NAME,1,15), SUBSTR(D.OBJECT_NAME,1,15),
SUBSTR(OBJECT_TYPE,1,10)
FROM DBA_DATA_FILES F,DBA_OBJECTS D
WHERE D.OBJECT_NAME LIKE 'T%'