How to check whether an object name is valid or not?

[yang99]

Hi all,

I came across a requirement to check whether a given object name is valid or not, according to ORACLE's naming regulation. In other words, I want to validate the name before I actually send the request (create, or select, or whatever) to the database.

Is there any server/client side function or tool dealing with this issue? FYI, the naming regulation is on page

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10759/sql_elements008.htm#sthref605.

Thanks

Yang

 

[sem]

I don't know about such function, but you may try to create an object and then just catch an error. BTW, using double quotes may allow almost arbitrary names, thus the length is the only restriction.

Regards, Dima

http://seminihin.narod.ru

 

[yang99]

Thanks Sem. You are right. By applying the length restriction plus checking double quotes is good enough for time being.

Yang