Re: DBA_ tables

I've just done the following with no difficulty:

select table_name from all_tables where table_name = 'ORDERS';

Looks like you need single quotes !
Obviously, you could replace the = with LIKE to get wildcard matches, which may be more useful to you.

                Simon :-)

Simon Holt 			|	Voice:	+44 (0) 1373 826826 x253
(Writing as an individual)	|	Inet:	holt_at_ntrust.org.uk   


-----------------------------------------------------------------------------

	My opinions are not necessarily those of my employer


-----------------------------------------------------------------------------