OraFAQ Forum: Forms » How To Store Special Characters in oracle database 8.1.5 from forms

Home » Developer & Programmer » Forms » How To Store Special Characters in oracle database 8.1.5 from forms

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

How To Store Special Characters in oracle database 8.1.5 from forms [message #263625]

Thu, 30 August 2007 09:28

qanita786
Messages: 229
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

Report message to a moderator

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

Littlefoot
Messages: 21826
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.

Report message to a moderator

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

qanita786
Messages: 229
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

Report message to a moderator

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

Littlefoot
Messages: 21826
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!

Report message to a moderator

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

qanita786
Messages: 229
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

Report message to a moderator

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

Littlefoot
Messages: 21826
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>

Report message to a moderator