BLOBS sizes.

From: Yaw <yawi_at_bigpond.com>
Date: Mon, 14 Jan 2002 12:19:57 GMT
Message-ID: <N1A08.14253$je.74640_at_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 - 13:19:57 CET

Original text of this message