Thanks for the question, ASHRAF.

Asked: June 25, 2001 - 7:33 am UTC

Last updated: August 14, 2019 - 2:26 am UTC

Version: 8i

Viewed 10K+ times! This question is

You Asked

hi tom
can you pls. tell me about
1- how can i encrypt data through network
2- i make schedule to exam DBA all i have background operating system is windows (NT,2000) and novell but i havn't any background about unix .... is it important to go through unix ?
3- can u tell me about this spell check u make can i browse the source

best reg
ashraf gamal

and Tom said...

1) search for dbms_obfuscation_toolkit on my site.

2) no.

3) Go to Resources and use the APEX interactive report search bar and search for "speling.tar"

followup to comment

not sure what you mean by that. DBMS_OBFUSCATION_TOOLKIT is a supplied pacakge with Oracle. It implements DES and 3DES encryption in the database.

No only can make use of your encrypted data unless they have your KEY. Protect your KEY and your data is protected. Having access to a real encryption algorithm does not make it any easier to crack the encrypted data.

followup to comment 3 below

you have the source code, you can make it do ANYTHING you want it to do.

Rating

(12 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

it it useful but

ashraf gamal, June 25, 2001 - 9:32 am UTC

this mean that any one can have this toolkit and browse the data i need encryption that certified for internal or external database users

ok

ashraf gamal, June 26, 2001 - 1:54 am UTC

thanks tom

disabling add new word in dictionary

reader, June 28, 2001 - 6:43 am UTC

how can i disable add new word in dictionary.

spell checker

Jeff, December 31, 2002 - 9:17 am UTC

Tom,
1.) How do I start a new question on Ask Tom? The HELP ? button at top did not help me to figure out how to ask a new question. I see no links for that? I only see reviews.

2.) I want to spell check text or varchar2() columns? Is there a spell check function available?

Thanks,
jeff

December 31, 2002 - 10:02 am UTC

1) on the home page, upper right hand corner, it says:

Sorry I have a
large backlog
right now, please
ask a question later

To ask a question
click on the "Submit
a New Question" button
or Ask A Question. <<== thats a link

when you see the "sorry", i'm not taking any.

2) download the spelling.tar from above, rip it apart and get just the routine to do the spell check without the HTML stuff. All of the routines are in there, just use the one you want.

Spell checker

Laxman Kondal, July 25, 2005 - 9:24 am UTC

Hi Tom

We have few columns (varchar2 (2000))in various tables and they are comments and descriptions, and I am looking for some tool to do spell chek but the link above shows page not found.

Is there any Oracle tool or procedure/function or third party tool which can be used with Oracle9i, to check spelling before inserting into database.

Thanks and regards

July 25, 2005 - 11:07 am UTC

try now

Spell checker

Laxman Kondal, July 25, 2005 - 2:02 pm UTC

Hi Tom

Thanks, link is working now. I will try to use this.

Thanks and regards.

Spell Checker

Kim, November 04, 2010 - 10:33 am UTC

I would like to run spell check on a few columns in our Oracle database table. I noticed you had a solution listed at:
http://asktom.oracle.com/~tkyte/speling.tar
I am not able to reach this page at this time.

Is the page still available or can you repost your solution?

Thanks in advance,
Kim

November 05, 2010 - 5:05 am UTC

http://asktom.oracle.com/pls/asktom/z?p_url=ASKTOM%2Edownload_file%3Fp_file%3D5046755609760427311&p_cat=speling.tar&p_company=822925097021874

Spell Check using Oracle Text

Shubh, May 05, 2016 - 6:11 am UTC

Hi Tom,

The URL provided for spell check is not working. Is this changed?

May 05, 2016 - 6:29 am UTC

Go to Resources tab, and scroll down to files. It will be in that list somewhere.

Hope this helps.

Spell check using Oracle text

Shubh, May 05, 2016 - 8:26 am UTC

I tried finding dpeling.tar in the resources tab but could not find it. Can you please help me with that

May 05, 2016 - 10:19 am UTC

Click on Resources
Scroll down to Files

The list will show the *first* 15 files, but there is lots more. Keep hitting the arrow at the bottom of the list to scroll through them.

(Yes, we need to improve this...but that how it is currently)

spell check using Oracle text

Shubhanshu Chandra, May 05, 2016 - 12:04 pm UTC

Thanks again for the reply but I tried searching in all the 222 rows for the speling.tar or anything relative in the description column but maximum of them are the OUG presentation zip files for different regions and nothing related to spell check is mentioned.

If you can help me with the description then it will be really helpful.

Appreciate your help in the context.

Direct Link

Paul, May 05, 2016 - 2:39 pm UTC

https://asktom.oracle.com/pls/apex/f?p=100:DOWNLOAD:1517662152714:APPLICATION_PROCESS=DOWNLOAD_FILE:NO:RP:GET_TYPE,GET_ID:PRESENTATION,40395599290646089784376841733917154663

I went to Resources, Sorted Presentations by Name Descending and found this link.

Hope that is what you were looking for.

May 06, 2016 - 1:29 am UTC

Yeah... it didnt seem that hard :-)

(Thanks for doing the work)

Direct Link didn't work, but you can search

A reader, August 13, 2019 - 2:05 pm UTC

I tried the direct link posted by; however, you can now go to Resources and use the APEX interactive report search bar. Just make note, its speling.tar ( not spelling )

August 14, 2019 - 2:26 am UTC

Thanks, we'll update the answer.

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library

Breadcrumb

Question and Answer

You Asked

and Tom said...

Rating