CREATE TABLE test_table ( id NUMBER, image BLOB);The trick now is get your application to store the image in the table. The Oracle Application Developer's Guide -- Large Objects contains step-by-step examples for PL/SQL, OCI and Pro*C application development platforms.
If you are using Oracle Forms as your development platform, then there are two functions in Forms that are of interest to you, READ_IMAGE_FILE and WRITE_IMAGE_FILE. Rather than reinvent the wheel, I'll send you to one of the best resources around, AskTom.
This was first published in May 2005