Click here to Skip to main content
12,953,014 members (47,892 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
I have created this first table.............
SQL> desc graphics
 Name                                       Null?    Type
 ----------------------------------------- -------- --------------------
 BFILE_ID                                           NUMBER
 BFILE_DESC                                         VARCHAR2(30)
 BFILE_LOC                                          BINARY FILE LOB
 BFILE_TYPE                                         VARCHAR2(4)

Also I have created this another table
SQL> desc pictures
 Name                                       Null?    Type
 ----------------------------------------- -------- --------------------
 NAME                                      NOT NULL VARCHAR2(10)
 PIC                                                BLOB

I don't know how to insert and retrieve picture from both of tables..

Since I am beginner to this syntax....

I want to ask that which one method is suitable and comparatively easy to insert and retrieve pictures from oracle database?????
Please help
Posted 21-Jan-13 0:55am
surkhi623
Updated 21-Jan-13 5:57am
v3

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 6,429
CHill60 3,490
Maciej Los 3,103
Jochen Arndt 1,975
ppolymorphe 1,920


Advertise | Privacy | Mobile
Web02 | 2.8.170525.1 | Last Updated 21 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100