|
Re: How to identify special character [message #609863 is a reply to message #609861] |
Thu, 13 March 2014 06:04 |
|
Michel Cadot
Messages: 68624 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
SQL> select * from sce_att
2 where length(translate(SCENARIO_SHORT_NAME,'A$%#@%','A'))!=length(SCENARIO_SHORT_NAME)
3 or length(translate(SCENARIO_LONG_NAME,'A$%#@%','A'))!=length(SCENARIO_LONG_NAME)
4 /
SCENARIO_SHORT_NAME
---------------------------------------------------------------------------------------------
SCENARIO_LONG_NAME
---------------------------------------------------------------------------------------------
EquityUp$%#@%
EquityUp$%#@%
1 row selected.
|
|
|