select distinct column_name from all_tab_cols where column_name like 'FREELIST%'
and SUBSTR(column_name, 9, 1) = '_'
-----Original Message-----
From: Tore Sævik [mailto:oracledba-ezmlmshield-x98013687.[Email address protected]
Sent: Tuesday, July 04, 2006 2:15 PM
To: LazyDBA Discussion
Subject: '_' in sql-query
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
**********************************************************************
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree to these terms:http://www.lazydba.com/legal.html
--
This message has been scanned for viruses and
dangerous content by OpenGaming Security System and is
believed to be clean.
Have a nice day,
This e-mail and any attachments may contain information that is confidential, proprietary, privileged or otherwise protected by law. The information contained herein is solely intended for the named addressee (or a person responsible for delivering it to the addressee). If you are not the intended recipient of this message, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete it from your computer.
Oracle LazyDBA home page