Find Database Objects and regexp??

[limerdove]

If I want to find the objects that start with f_get and end with rowid, how can I do that?
Or if I want to find all objects that end with rowid, how can I do that?

example:
f_get*rowid

example
*rowid

 

[rbrooker]

1:
select * from all_objects where lower( object_name ) like 'f_get%rowid'

2:
select * from all_objects where lower( object_name ) like '%rowid'

 

[limerdove]

I forgot to mention that I was trying to find the object using the "FIND DATABASE OBJECTS" feature of the PL/SQL DEVELOPER PROGRAM. The binocular icon next to the wrench icon.

If I try to find an object like this using regexp:
*rowid

It will try to query but never seems to come back. I end up killing the pl/sql program in order to stop the find.

 

[Marco Kalter]

Maybe you have a lot of objects in the database, and the search is slow?

Anyway, there is no way to search by object name. It will always do a full text search. In version 6.0 you can search by name and other properties.