Wednesday, 12 June 2013

query to display all the tables that contains '_' (underscore) symbol?

select *from all_objects where object_name like '%*_%' escape '*';

No comments:

Post a Comment