Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> BLOBS sizes.

BLOBS sizes.

From: Yaw <yawi_at_bigpond.com>
Date: Mon, 14 Jan 2002 12:19:57 GMT
Message-ID: <N1A08.14253$je.74640@news-server.bigpond.net.au>


Hi all,

  1. I was wondering what how do you calculate the column size Oracle8i (or any other version) allocates to something such as a 1MB BLOB (to add a picture)
  2. How do I create a table with a column that takes a BLOB of 1MB? Is it just: create table... picture blob(1MB) ... ?

Any help you can give is much appreciated.

Thanks in advance.

Yaw. Received on Mon Jan 14 2002 - 06:19:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US