How to store picture files into table?

[sanjida]

Is there any datatype for it
pls help me

[musha_2000]

Hi
if u want store pictures or jpg file make the data type LONG RAW in the table
by musha

[prasanta_rath]

Step 1).
SQL> Create table pkr_pic
(pic long raw);

Step 2).
Now create a form, Using Oracle Developer.
Run it.
Press: Insert a record (On runing oracle form)
open any picture "right click on the picture" and copy.

Step 3).
On Runing Form go to "Edit" and then paste.

Step 4).
Press Save (On runing oracle form)

[Adara]

Before you can create and execute a procedure to load binary data from the file system into an Oracle table, you will need a table with a blob column and an Oracle directory pointing to the location on the file system, where the binary files are stored. Below I have examples of how to create an Oracle directory, a table with a blob column and a procedure to load binary files:

/*-- Create the Directory ------*/
CREATE OR REPLACE DIRECTORY
BLOB_FILE AS 'D:\BFILE';

Where "d:\bfile" is the location of the binary files.

--
-- DEMO (Table)
--
CREATE TABLE DEMO
(
ID INTEGER,
THEBLOG BLOB
)
TABLESPACE TS_BLOB

LOB (THEBLOG) STORE AS
( TABLESPACE CODE_TABLE_DATA
ENABLE STORAGE IN ROW