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

Thread: Handling BLOBs info wanted !!!

  1. 04-16-2003, 03:03 AM #1
    GKramer
    GKramer is offline Junior Member
    Join Date
    Apr 2003
    Location
    Rosmalen, Netherlands.
    Posts
    73

    Handling BLOBs info wanted !!!

    Hi to you all,

    I have to examen a database containing some tables with BLOBs and I'm used to work with SQL*PLUS for quick and easy access to make some datasets. SQL*PLUS does not support tables ( columns ) containing BLOBs. Can anyone give me some advise how to extract data from these tabels showing the content of thes BLOB fields.

    Talking about BLOBs; this is pretty new to me so I like to know more of how to use them ( what are the benefits ) and how to handel them ( insert ( from os-filelocation ), alter and showing them) any detail on this is welcome. Perhaps you can point me to a referance somewhere on the Internet or suggest a good book.

    Thanks in advance.

    GKramer.
    Reply With Quote Reply With Quote
  2. 04-16-2003, 03:04 AM #2
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well you need some GUI tool, read the doco and you will be welcome
    Reply With Quote Reply With Quote
  3. 04-16-2003, 03:06 AM #3
    GKramer
    GKramer is offline Junior Member
    Join Date
    Apr 2003
    Location
    Rosmalen, Netherlands.
    Posts
    73
    Pando,

    What a quick reply !!!
    Which kind of GUI tool and Which doco do you mean?

    GKramer
    Reply With Quote Reply With Quote
  4. 04-16-2003, 03:20 AM #4
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Oracle Developer, J2EE, Web jonx etc etc
    Reply With Quote Reply With Quote
  5. 04-16-2003, 06:14 AM #5
    Tarry's Avatar
    Tarry
    Tarry is offline Senior Advisor
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    By doco he means to check out here..

    http://otn.oracle.com/docs/products/...ase2/index.htm

    and you can indeed access blob's thru sqlplus, you must use dbms_lob, and utl_raw pkgs
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---
    Reply With Quote Reply With Quote
  6. 04-16-2003, 06:32 AM #6
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you can access but what´s the point seeing tons of j0nx on your screen?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width