SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to find the special character in a give string/sentance

781064Jul 21 2011 — edited Jul 25 2011

Hi All,

I have one task to complete with in the give time. Since i am not very good in PL/SQL i need your your help.
Requirement is :

I have to come up with the SQL or PL/SQL code which should return and find the special or hidden character in the datafiles name in a database. There are nearly 400+ database are present in almost all the flavor of UNIX and i have to check the each and every database.

As you know , Name of the data file will be like this :

 /u02/instance_name\oradata\datafile_01.dbf

So it should avoid these things and find out only the special characters in the datafile name.

 
a-z , A-Z , 0-9 and \

Please keep in mind that ...... I will be firing the Oracle script from Oracle 9i client which will access all the database from Oracle 9i to 11g in one short and give me the result.

Please help me to resolve this issue and let me know if you need more information.

This post has been answered by Frank Kulash on Jul 22 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 22 2011

Added on Jul 21 2011

#11g, #9i, #database, #pl-sql, #plsql, #query, #sql

8 comments

10,793 views