Home » Developer & Programmer » Forms » How To Store Special Characters in oracle database 8.1.5 from forms
How To Store Special Characters in oracle database 8.1.5 from forms [message #263625] Thu, 30 August 2007 09:28 Go to next message
qanita786
Messages: 213
Registered: May 2007
Location: PAKISTAN
Senior Member
How To Store Special Characters in oracle database 8.1.5 from forms for example i want to store password in a table in special character
Re: How To Store Special Characters in oracle database 8.1.5 from forms [message #263664 is a reply to message #263625] Thu, 30 August 2007 12:45 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Are you sure you want to store password in such a way? It can easily be cracked (not that I can do that, but - believe me - there are bad guys who can).

OK, here it is: the simplest way would be to use the TRANSLATE function. First, code something:
SQL> SELECT TRANSLATE('this is password',
  2                   'abcdefghijklmnopqrstuvwxyz',
  3                   '!"#$%&/()=?*+-.,;:_<>\|[]z'
  4                  ) result
  5  FROM dual;

RESULT
----------------
<()_ )_ ,!__|.:$
And now, decode it back:
SQL> SELECT TRANSLATE ('<()_ )_ ,!__|.:$',
  2                    '!"#$%&/()=?*+-.,;:_<>\|[]z',
  3                    'abcdefghijklmnopqrstuvwxyz'
  4                   ) result_decoded
  5  FROM dual;

RESULT_DECODED
----------------
this is password
Is this what you are looking for? If not, I'm afraid I misunderstood you.

However, you might take a look at this Frank Naude's script which uses DBMS Obfuscation Toolkit to encrypt and decrypt a value. As your database version is quite old, I'm not sure it supports this feature; I've found a source which says that it was introduced in 8.1.6, so - it seems that you're out of luck here.
Re: How To Store Special Characters in oracle database 8.1.5 from forms [message #264029 is a reply to message #263664] Fri, 31 August 2007 09:38 Go to previous messageGo to next message
qanita786
Messages: 213
Registered: May 2007
Location: PAKISTAN
Senior Member
Its work very good only for alpha but i want to store alpha and numeric Thanks a lot for positive response
Re: How To Store Special Characters in oracle database 8.1.5 from forms [message #264037 is a reply to message #264029] Fri, 31 August 2007 09:49 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So include numbers in there! Just make sure there are enough special characters for all slphanumerics!
Re: How To Store Special Characters in oracle database 8.1.5 from forms [message #264081 is a reply to message #264037] Fri, 31 August 2007 12:26 Go to previous messageGo to next message
qanita786
Messages: 213
Registered: May 2007
Location: PAKISTAN
Senior Member
I add Numbers from 0-9 with characters where charaters defined like 'abc-z0123456789' but this command not translate 0-9 this command show same as we addd for example
Password is 'This is Faheem122' so translate command transfer alpha to special character but 122 display same as i type
Re: How To Store Special Characters in oracle database 8.1.5 from forms [message #264103 is a reply to message #264081] Fri, 31 August 2007 15:38 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It happened because you DIDN'T TRANSLATE numbers! I told you, make sure you have enough special characters.

In the following example, I chose 'germanikus' (10 letters for 10 numbers, 0 - 9):
SQL> SELECT TRANSLATE('this is password 3009968',
  2                   '0123456789abcdefghijklmnopqrstuvwxyz',
  3                   'germanikus!"#$%&/()=?*+-.,;:_<>\|[]z'
  4                  ) result
  5  FROM dual;

RESULT
------------------------
<()_ )_ ,!__|.:$ mggssiu

SQL>
Re: How To Store Special Characters in oracle database 8.1.5 from forms [message #264134 is a reply to message #264103] Sat, 01 September 2007 00:38 Go to previous messageGo to next message
qanita786
Messages: 213
Registered: May 2007
Location: PAKISTAN
Senior Member
Its Work very well but how to decode this password
Re: How To Store Special Characters in oracle database 8.1.5 from forms [message #264157 is a reply to message #264134] Sat, 01 September 2007 03:39 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'd try to find a fortune teller and ask her.

P.S. Are you serious?!? But really, REALLY serious when you asked this question?
Previous Topic: Form message
Next Topic: When Validate Item Trigger problem.................
Goto Forum:
  


Current Time: Sun Dec 04 06:43:02 CST 2016

Total time taken to generate the page: 0.04109 seconds