Computer Webmaster Gaming Console Graphics Forum

Welcome to the Computer Webmaster Gaming Console Graphics Forum forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact us.

MK PitStop Main Earn $25 Earn Money Posting Extras Members Blogs Image Hosting User Pages
Go Back   Computer Webmaster Gaming Console Graphics Forum > Webmaster Forum > Website Coding > Database
Register FAQ/Rules Become A V.I.P. Member Search Today's Posts Mark Forums Read

Database Database problems or need to ask a question? maybe something to do with sql injections or a database software question. Database topics cover MySQL, PostgreSQL, Oracle, SQL Server or anything else related to databases.

Google
Reply
 
LinkBack Thread Tools Display Modes
Old 07-10-2006, 6:07 AM   #1
eric
Member Level 3
 
eric's Avatar
 
Join Date: Jul 2006
Posts: 49
My Photos: (0)
iTrader: (0)

Banked:
MK Cash: $0.00

I am Worth:
MK Cash: $0.00
Donate

Recent Blog: None

eric is on a distinguished road
Default Encription in Oracle

here is a simple program is wrote for one of my projects to encript data in Oracle.
create or replace function estring(p_var varchar2)
return varchar2
is
v_estr varchar2(255);
v_elength number;
ipos number;
xor number;
begin
--Ensure password IS NOT case-sensitive
p_var := lower(p_var);
--Only encrypt IF parameter IS NOT NULL
if p_var is not null then
v_elength := length(p_var);
-- CREATE the KEY using a combination the the lenth OF the password +
the pos of the 3rd char found in the PW.
xor := v_elength + instr(p_var, substr(p_var, 3, 1));
ipos := 1;
v_estr := '';
while ipos <= v_elength loop
v_estr := v_str || to_char(to_ascii(substr(p_var, ipos, 1)) ^ xor);
ipos := ipos + 1;
end loop;
return(v_estr);
else
v_estr := null;
return(v_estr);
end if;
end estring
eric is offline  
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit!
Reply With Quote
Advertisements
Old 07-11-2006, 4:20 AM   #2
marriane
Member Level 3
 
marriane's Avatar
 
Join Date: Jul 2006
Posts: 35
My Photos: (0)
iTrader: (0)

Banked:
MK Cash: $0.00

I am Worth:
MK Cash: $0.00
Donate

Recent Blog: None

marriane is on a distinguished road
Default

Hi,
this is a good function, however i do have a question in mind about
v_estr := v_str || to_char(to_ascii(substr(p_var, ipos, 1)) ^ xor);
would you please explain this line?
marriane is offline  
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit!
Reply With Quote
Old 07-16-2006, 5:50 AM   #3
harry
Member Level 3
 
harry's Avatar
 
Join Date: Jul 2006
Posts: 36
My Photos: (0)
iTrader: (0)

Banked:
MK Cash: $0.00

I am Worth:
MK Cash: $0.00
Donate

Recent Blog: None

harry is on a distinguished road
Default

this line is used to convert the data in ascii digits while doing some calculations
harry is offline  
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit!
Reply With Quote
Featured Websites
Free Space
Free Space
Free Space Free Space
Reply
Tags: ,




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Encription in mysql eric Database 2 07-16-2006 5:49 AM


Featured Websites




All times are GMT +1. The time now is 3:33 PM.


Powered by: vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.0.0
Cheap Computers
MK PitStop Copyright 2005 - 2008

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98