Home » SQL & PL/SQL » SQL & PL/SQL » How to Create Table with CLOB column (Size 1 GB Only) (Oracle 10G)
How to Create Table with CLOB column (Size 1 GB Only) [message #408531] Tue, 16 June 2009 10:35 Go to next message
bholeuday
Messages: 28
Registered: April 2009
Location: Talavali
Junior Member

Hi,

My question is how to Create Table with CLOB column (Size 1 GB Only) like

create table a (b clob);

But i want to specify the Size as 1 GB.

Please guide on the same.

Thanks in advance.
Re: How to Create Table with CLOB column (Size 1 GB Only) [message #408534 is a reply to message #408531] Tue, 16 June 2009 10:42 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.


When all else fails, Read The Fine Manual
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_7002.htm#sthref7382
Re: How to Create Table with CLOB column (Size 1 GB Only) [message #408539 is a reply to message #408531] Tue, 16 June 2009 10:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL Reference
Chapter 2 Basic Elements of Oracle SQL
Section Datatypes

Regards
Michel
Re: How to Create Table with CLOB column (Size 1 GB Only) [message #408545 is a reply to message #408531] Tue, 16 June 2009 12:20 Go to previous message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
what version of the database are you using? have you tried a check constraint with the (length(col_clob) < 1000000000)



create table t (junk clob,
constraint check_length check(length(junk) <= 1000000000))
Previous Topic: Days between
Next Topic: ORA-23319 error
Goto Forum:
  


Current Time: Wed Dec 07 22:13:05 CST 2016

Total time taken to generate the page: 0.10334 seconds