DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: image data type

  1. #1
    Join Date
    Mar 2001
    Posts
    4

    Question

    Hi,

    How can i store images (gif or jpg) in Oracle8?
    What is the data type and how to use it ?

    Thanks

    Nicolas

  2. #2
    Join Date
    Feb 2001
    Posts
    184
    In LongRow You can store Pictures, Graphics Etc.
    These dataTypes can not be used in Select Statements in SQL *Plus, They can be viewd in Front End applications.

    To store, Again you have to use From end Tool Like Developer to Store Images ...
    Thanks

  3. #3
    Join Date
    Mar 2001
    Posts
    4

    Question can i use blob

    can i use the data type Blob for storing images (jpg).
    Can i do this:
    create table photo (
    id number(1)
    image blob
    )

    And how to insert values ?

    Thanks


  4. #4
    Join Date
    Dec 2000
    Posts
    28

    Smile

    Hi nic,

    Yes, you can use BLOB as the data type. In addition you should be using DBMS_LOB package to insert the image into this BLOB type.

    You can refer book : Oracle Built-in packages by Steven Feuerstein (O'Reilly publications) for further help.

    thanks,
    AD

  5. #5
    Join Date
    Mar 2001
    Posts
    4

    Smile

    Hi,

    Could you give me an exemple of value insertion (with the Blob data type) .
    Does the book exist in French ?

    Thanks

    Nic

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width