title: Is it possible to set a BLOB size when creating table?
body: <p>I am new to Oracle sql, but I have some experience with MSSQL. I was sent a script to create some tables, but because of the BLOB columns, I am getting a couple errors when I try to limit the size.</p>
  
  <p>I tried asking my co-workers about this, but they aren't sure either. This was basically grabbed from somewhere else, so they're not sure how to fix this.</p>
  
  <p>Essentially, the table looks something like this (table and column names were changed):</p>
  
  <pre><code>CREATE TABLE table1
  (
      ID       CHAR(32),
      NAME     CHAR(50),
      KEY      $(BLOB)(64),
      BUFFER   $(BLOB)(20),
      SORTNO   NUMERIC(8) CONSTRAINT UK_WIU UNIQUE,
  CONSTRAINT PK_ID PRIMARY KEY (ID)
  )
  ;
  </code></pre>
  
  <p>When running this, I get the error "invalid character" because of the dollar sign ($). But if I change data type to BLOB(64), I get an error saying "missing right parenthesis." If I just do "BLOB," it runs fine. Is there any way to define the length for BLOB?</p>
  
  <p>Thank you</p>