selecting tables

[ugendrababu]

hi,
i want to retrieve table name starts with using select query in oracle 9i

thanks

babu

[ugendrababu]

selecting tables

hi,

i want to retrieve table name starts with "babu" using select query in oracle 9i

thanks
babu

[amitpatel66]

Please post what you have tried so far?

[amitpatel66]

Duplicate threads merged for better management of the forum

[Pilgrim333]

select table_name from all_all_tables
where upper(table_nam e) like 'BABU%'

This should give you what you want. The upper is not needed, but just in case, because like is case sensitive.

Pilgrim.

[amitpatel66]

So what is the problem?..Is that query working or any error?