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!

To find out " dot" using substr in oracle

user1758353Dec 29 2008 — edited Dec 31 2008

Hi ,

I would like to find "Dot" between Schemaname and table name using substring in Oracle . I am using oracle 9i.I can't use Regexp in Oracle 9i

Schemaname .tablename

Table name can be any no of characters

Schema name also can be any no of characters

Regards,
User

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 28 2009

Added on Dec 29 2008

4 comments

2,423 views