select distinct column_name from all_tab_cols where column_name like 'FREELIST_%'

returns

FREELISTS
FREELIST_GROUPS

I would like the query to return only the FREELIST_GROUPS value (I understand that _ means any caracther, but it sjould be possible to avoid this?



thanks








**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.powel.no
**********************************************************************


Oracle LazyDBA home page