Word-Based Password Generator

articles: 

Comments

Or the lazy man's way to load the data...

cat words | sed "s/^/insert into testuser.words values ('/g;s/$/')\;/g"

-- generates this
insert into testuser.words values ('10th');
insert into testuser.words values ('1st');
insert into testuser.words values ('2nd');
insert into testuser.words values ('3rd');
...

load data
Infile “
replace into table scott.words
(word char(50))

When I execute the above code it replies with ora-00900 invalid sql statement.

You have to put that text in your control file, not enter it directly into sqlplus.