How to store and retrive images in oracle database

10-11  Source: Network gathering  Views:1 

Advertisement
hi,
i am interested in storing some students pictures ( photos) into my oracle database, and i want to know since the images are considered as binary data and since BLOB and CBLOB and supported by oracle, how to insert and to select the picture from oracle from my swing-based application?
does anyone have a complete sample or tutorial doing that well!!
thx
Mira este link,
hay varios articulos interesantes.
http://www.oracle-base.com/articles/9i/Articles9i.php
tambien puedes consultar este link
http://tahiti.oracle.com/pls/db92/db92.homepage
completa los coampos solicitados con la palabra "Images"
hay un manual de LOBs muy completo
Related articles
  • How to store and retrive images in oracle database 10-11

    hi, i am interested in storing some students pictures ( photos) into my oracle database, and i want to know since the images are considered as binary data and since BLOB and CBLOB and supported by oracle, how to insert and to select the picture from

  • Urgent : store and retrieve image to oracle database thru applet 11-30

    hi all i want the code sample for storing the image to oracle database development enviornment: server : oracle 9i , apache web server client : ie6 browser i am connecting to oracle database thru applet using oracle jdbc thin driver can anyone give m

  • Can you suggest a best way to store and read arabic from oracle database? 11-30

    Hi , can you suggest a best way to store and read arabic from oracle database? My oracle database is Oracle Database 10g Release 10.1.0.5.0 - 64bit Production on unix HP-UX ia64. NLS_NCHAR_CHARACTERSET AL16UTF16 NLS_LANGUAGE AMERICAN NLS_TERRITORY AM

  • How do i store and fetch image from the Database(Access) 11-30

    i am facing one problem in inserting the image into the database.the steps i followed as 1)i have created one database(access) as "Image" and into that one table as "Image" and field as "image" type of the field is ole object

  • How to store an excel sheet in oracle database 10-11

    How can I store excel sheet into oracle.Or you could use Heterogenous Services to treat Excel as an external database: 1- Go to Control Panel>Administrative Tools>Data Sources (ODBC)>System DSN and create a data source with appropriate driver. Na

  • How to store India Regional language in oracle database 10-11

    Hi, Can any guide us how can we store data in Indian regional languages in Oracle database. We are using Oracle 10g. Also i need to know can we convert existing data in oracle to local language ? ThanksB_M_A wrote: Hi, Can any guide us how can we sto

  • How to store BDC error messages into oracle database table? 11-30

    Hello Experts, I have a peculier requirement wherein I need to store the error messages occured while executing the transaction using BDC (Call Transaction Method) in an Oracle Database table format. Is that possible, if yes, how? Thanks in advance.H

  • How to store data from xml in oracle database 10-11

    Hello All Could anyone tell me ways of storing XML in Oracle and whats the best one in terms of performance issues. any URL to this q/s would be great. thanks kedarBen, The following link as some information regarding DOM API and XSQL. http://asktom.

  • How to Store PDF files In the Oracle Database? 10-11

    Hi All, It is required for me to store the PDF files in the Database and retrieve it back whenever necessary. Also I need to store it with some security. So no one can read the content of the file. Please give me solution to these problems. Thanksvas

  • How to store and retrieve image in a apache derby using JDBC 10-11

    hi all this is source code i copy and modify but get error message like this import java.io.*; import java.sql.*; import java.util.Properties; import java.awt.*; import javax.swing.*; public class ImageDemo{ public static void main(String argv[]){ tr

  • How to store en-crypted  passwords in Oracle database. 10-11

    There are several user IDs for whom passwords are to be stored in database which are to be encrypted and there should be a function to compare the passwords entered with the passwords stored in the database . Could any one let me know how to do this

  • How to set and retrive the index log path stored by parameter LOG_DIRECTORY 10-11

    how to set and retrive the index log path stored by parameter LOG_DIRECTORY.http://download-west.oracle.com/docs/cd/B19306_01/network.102/b14213/lsnrctl.htm#sthref72 http://download-west.oracle.com/docs/cd/B19306_01/network.102/b14213/cmctl.htm#sthre

  • How to store the zip file in oracle table? 10-11

    hi, How to store the zip file in oracle table ? is it possible to unzip and read the file ? Thanks Rangan SSQL> DESC BLOB_TABLE; Name Type Nullable Default Comments A INTEGER Y B BLOB Y SQL> INSERT INTO BLOB_TABLE VALUES(5,BLOB('MWDIR_TST','TEST.ZIP

  • Help abt store and delete images as blob & bfile using Visual C++ 11-30

    Hi Does anyone knows if there is code for visual c++ to store and delete images as blob or bfile? thanxThe documentation states there are examples in the oracle database distribution: <ORACLE_HOME>/rdbms/demo/cdemolb.c <ORACLE_HOME>/rdbms/demo

  • How to create a Macro in excel to store the excel data to Oracle Database 10-11

    Hi All Does anyone has created a macro in excel which on being run stores the excel data to Oracle database. In my project I need to create one such macro for updating oracle database with excel data and another for inserting excel records. I tried d

  • How to store and retrieve chinese characters 11-30

    Hi, I am facing some problem in storing and retrieving of chinese characters from oracle,9i . This is the character i am trying to store into the database 自动提款机网络 while trying to retrieve it, it shows 自?提款机网? ^ ^ you can see t

  • Storing PDF and Word document in oracle database 10-11

    any idea, how to store PDF and word document using oracle database. thanksThe common approach is store as BLOB in database, use DBMS_LOB package to handle the loading and reading, sample script source asktom Also check this thread in Asktom SQL> crea

  • How to handel a Batch job in oracle database 10-11

    How to handel a Batch job in oracle database? Regards alokAlekh wrote: lists of jobs execute concurrently.Thats a definition we all aware of ;), I meant do you want to execute the jobs in a sequence? is there any dependency? is it more like schedulin

  • Any reference about Business and Technology Intelligence in Oracle Database 11-30

    Kindly provide me any link, reference , document, white paper to look at the idea that what is the Business and technology intelligence in Oracle Database.. We have see this in this perspective that " How oracle is making money from his database tech

  • Recommended Third Party Archive and Purging Software for Oracle Database (Oracle CC&B) 11-30

    Hi, We are currently exploring third party archive and purging software for Oracle Database specifically used by an Oracle Customer Care and Billing implementation. Our current data is growing that we think archiving and purging is a now a viable opt