Upload an image into a column with Blob data type on Oracle SQL
I have this table (Image_uploads) with the following columns and data types:
NAME -VARCHAR2(256 BYTE),
MIME_TYPE -VARCHAR2(128 BYTE),
DOC_SIZE -NUMBER,
DAD_CHARSET -VARCHAR2(128 BYTE),
LAST_UPDATED -DATE,
CONTENT_TYPE -VARCHAR2(128 BYTE),
CONTENT -LONG RAW,
BLOB_CONTENT -BLOB.
The column called blob_content is where I want to upload the image to. I used to use an app, but it was decommissioned, now I have to upload using the SQL developer, how do I do this?
Solution
- insert a new record
- double click the CONTENT column so that the pencil icon shows - click it
- in the next window, click Load
- select a file, click "open"
- commit changes
- Reorder rows in a MySQL table
- Need to truncate a timestamp and add a minute to it in SQL
- Shortcut for Question marks in preparedStatement for parameterized query
- Correctly Migrate Postgres least() Behavior to BigQuery
- Dealing with single quotes in excel vba sql queries
- Data is Null. This method or property cannot be called on Null values
- Redshift GROUP BY ALL syntax not supported
- How to simulate GREATEST() in Sybase ASE?
- Retrieve data from 3 tables with 2 conditions
- How to LOCK with READ COMMITTED SNAPSHOT
- How to save the result of a condition (IF) into a variable?
- SQL query to get students who have enrolled in English or Urdu course but not in both
- Mysql Where Calculate
- MySql reuse alias for WHERE clause
- Filter by distance in the same query that calculates it with MySQL?
- Age calculation not working
- MYSQL using alias in the WHERE clause
- WHERE clause to filter times that are under an hour
- Unknown column for calculate field in MySQL
- Calculated column in where-clause - performance
- mysql calculation results in WHERE clause
- Getting previous column values in a new column
- Why do we always prefer using parameters in SQL statements?
- SQL Statement using Where clause with multiple values
- I am getting the following error when I am inserting a all the lines of a very large log file into ms sql server 2008
- how to see generated sql from a linq query
- Snowflake PARSE_JSON pattern match for keys
- Get a result set flagging where there is a history going back 3 months
- Chaining joins in SQL based on dynamic table
- what are the alternative methods to replace SSRS Subscription?