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.
Dig deeper on Oracle database backup and recovery
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.