Use escape character \
set escape on;
select distinct column_name from all_tab_cols where column_name like
'FREELIST\_%'
It should return only FREELIST_GROUPS
Thanks and Best Regards,
Avneesh Kumar Rathor
"Tore Sævik " <oracledba-ezmlmshield-x98013687.[Email address protected]
4 July 2006 13:14 ZE2
To
"LazyDBA Discussion" <[Email address protected]
cc
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
Whilst this email has been checked for all known viruses, recipients should undertake their own virus checking as Xansa will not accept any liability whatsoever.
This email and any files transmitted with it are confidential and protected by client privilege. It is solely for the use of the intended recipient.
Please delete it and notify the sender if you have received it in
error. Unauthorised use is prohibited.
Any opinions expressed in this email are those of the individual and not
necessarily the organisation.
Xansa, Registered Office: 420 Thames Valley Park Drive,
Thames Valley Park, Reading, RG6 1PU, UK.
Registered in England No.1000954.
t +44 (0)8702 416181
w www.xansa.com
Oracle LazyDBA home page