OraFAQ Forum: Suggestions & Feedback » "@" symbol being interpreted as email address

Home » Other » Suggestions & Feedback » "@" symbol being interpreted as email address

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

"@" symbol being interpreted as email address [message #538824]

Mon, 09 January 2012 11:26

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

How can I stop this sort of connect string being interpreted by OraFAQ as an email address:

sqlplus scott/tiger@127.0.0.1@1521/orcl

I know I can put it in [code] tags, but sometimes that really isn't appropriate. I tried the [notag] tag, and a few other things.

(I need an emoticon for "realize this is probably a FAQ and hope not to get flamed for asking".)

Report message to a moderator

Re: "@" symbol being interpreted as email address [message #538827 is a reply to message #538824]

Mon, 09 January 2012 11:35

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Let me try;

scott/tiger@127.0.0.1

Report message to a moderator

Re: "@" symbol being interpreted as email address [message #538828 is a reply to message #538827]

Mon, 09 January 2012 11:36

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Aaaaahhhhh, am I smart or what?

Report message to a moderator

Re: "@" symbol being interpreted as email address [message #538829 is a reply to message #538828]

Mon, 09 January 2012 11:40

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

Yes, but:

sqlplus scott/tiger@127.0.0.1
sqlplus scott/tiger@127.0.0.1:1521
sqlplus scott/tiger@127.0.0.1:1521/orcl

Report message to a moderator

Re: "@" symbol being interpreted as email address [message #538830 is a reply to message #538828]

Mon, 09 January 2012 11:41

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

No, I'm not that smart, Michel taught me that little trick. You need to write monkey's (at sign's) HTML code which consists of:
- ampersand &
- hash #
- decimal ASCII of the monkey sign 64
- semi-colon ;

This:

/forum/fa/9708/0/

Beware of previewing your message, because it will be lost ... again.

Attachment: curse_of_monkey_island.PNG
(Size: 0.98KB, Downloaded 3150 times)

Report message to a moderator

Re: "@" symbol being interpreted as email address [message #538832 is a reply to message #538830]

Mon, 09 January 2012 11:43

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

sqlplus scott/tiger@127.0.0.1:1521/orcl

Report message to a moderator

Re: "@" symbol being interpreted as email address [message #538834 is a reply to message #538832]

Mon, 09 January 2012 11:47

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Forgot to mention: you'd experience the same with, for example, square brackets (used in regular expressions): look at this rubbish code:

regexp_substr('my string 123', ':digit:+$')

Instead of a square bracket, I should have used & # 91 ;

Report message to a moderator