Home » Other » Suggestions & Feedback » "@" symbol being interpreted as email address
"@" symbol being interpreted as email address [message #538824] Mon, 09 January 2012 11:26 Go to next message
John Watson
Messages: 4102
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".)
Re: "@" symbol being interpreted as email address [message #538827 is a reply to message #538824] Mon, 09 January 2012 11:35 Go to previous messageGo to next message
Littlefoot
Messages: 18847
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Let me try;

scott/tiger@127.0.0.1
Re: "@" symbol being interpreted as email address [message #538828 is a reply to message #538827] Mon, 09 January 2012 11:36 Go to previous messageGo to next message
Littlefoot
Messages: 18847
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Aaaaahhhhh, am I smart or what?
Re: "@" symbol being interpreted as email address [message #538829 is a reply to message #538828] Mon, 09 January 2012 11:40 Go to previous messageGo to next message
John Watson
Messages: 4102
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
Re: "@" symbol being interpreted as email address [message #538830 is a reply to message #538828] Mon, 09 January 2012 11:41 Go to previous messageGo to next message
Littlefoot
Messages: 18847
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:

./fa/9708/0/

Beware of previewing your message, because it will be lost ... again.
Re: "@" symbol being interpreted as email address [message #538832 is a reply to message #538830] Mon, 09 January 2012 11:43 Go to previous messageGo to next message
Littlefoot
Messages: 18847
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator

sqlplus scott/tiger@127.0.0.1:1521/orcl
Re: "@" symbol being interpreted as email address [message #538834 is a reply to message #538832] Mon, 09 January 2012 11:47 Go to previous messageGo to next message
Littlefoot
Messages: 18847
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 ;
Re: "@" symbol being interpreted as email address [message #538835 is a reply to message #538832] Mon, 09 January 2012 11:51 Go to previous messageGo to next message
John Watson
Messages: 4102
Registered: January 2010
Location: Global Village
Senior Member
How bizarre.
(which was a one-hit-wonder by OMC 20 years ago)
Re: "@" symbol being interpreted as email address [message #539019 is a reply to message #538835] Tue, 10 January 2012 15:35 Go to previous message
joy_division
Messages: 4454
Registered: February 2005
Location: East Coast USA
Senior Member
John Watson wrote on Mon, 09 January 2012 12:51
How bizarre.
(which was a one-hit-wonder by OMC 20 years ago)


They used to sing that song about me where I worked in 1999.
Previous Topic: nothing is being marked as read since recent maintenance
Next Topic: Request against spammer
Goto Forum:
  


Current Time: Thu Apr 24 23:44:41 CDT 2014

Total time taken to generate the page: 0.25631 seconds