www .Just SQL. com  

Script Name :

Description :

a site for the SQL*Plus specialist

Site Map


Scan varchar2 fields in a specified table for non-printable ascii characters.

Two scripts are presented.

Both require the input of a table to scan. Both will then identify all columns in the specified table which are of type varchar2 with either a length greater than 10, or a value input by the user (second script only).

Script FIND_NON_PRINTERS is submitted from the SQL> prompt with the name of the table to scan appended as an arguement.

The script FIND_NON_PRINTERS_PROMPT requires no arguements, but prompts the user for the name of the table to scan, the ascii character to scan for, and the minimum character length of the varchar2 fields above which they will qualify for scnaning. Enter any valid ascii (2-digit) number when prompted.

[Home] [Inspiration] [About this Site] [Scripts Intro] [Publications]

e-Mail Connection