There is no way to edit a BLOB in SQL*Plus aside from using the DBMS_LOB package. Unfortunately, there is no way to rotate an image with this package. You'll have to pull the image out of the database, store it on disk somewhere, and then use an image processing program to perform the rotation before saving the image back to the database table. How do you pull the image out of the database? The answer all depends on your application platform. Each one is different. This document will give you information for a number of application development platforms.
Dig deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.