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
- DateTime2 vs DateTime in SQL Server
- Generate Dates between date ranges
- Why (and how) to split column using master..spt_values?
- Oracle-DB, Joining 3 Tables Limiting the second without using LATERAL() or nesting
- How to convert sql table into a pyspark/python data structure and return back to sql in databricks notebook
- Get rendered SQL from CodeIgniter active record script
- Materialized view in Marketing Performance DB in Azure SQL database
- mysql delete under safe mode
- SQL SELECT WHERE field contains words
- SQL Server: group dates by ranges
- Get day of week in SQL Server 2005/2008
- The table has no ID, the date is contained in two columns
- Creating an index on a table variable
- How to drop all tables except 1
- Pyspark: Select all columns except particular columns
- How do I grant read access for a user to a database in SQL Server?
- MariaDB : create database and execute sql script without '<' character from the command line cmd.exe
- Find records with only one id
- MySQL - Get the first and last day of previous week
- Implementing iteration in Standard SQL (BigQuery)
- Concatenate dataframes in a loop where some of them may have no values
- SQL update with join is only updating one column
- Nested LAG function (kind of)
- Get SQL to get all records from a usertable and those matching uids from second table or return null
- SQL query to find duplicate rows based on multiple columns
- SQL Server Add row number each group
- How to calculate FIFO in SQL using matching overlapping blocks (using JOIN instead of UNION)
- How do I spool to a CSV formatted file using SQLPLUS?
- what is a foreign key and why you use it?
- What is semi-join in database?