Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

BINARY and VARBINARY Datatypes

934896Feb 3 2014 — edited Feb 3 2014


Hi

I am trying to create a table with datatypes Binary and VARBINARY this is what I have for DDL.

CREATE TABLE bvar (COL1 BINARY(10), COL2  VARBINARY(10));

I get an error ORA-00907: missing right parenthesis. I cant figure out why I am getting that error.

Please help. The database is 11g

Thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 3 2014
Added on Feb 3 2014
6 comments
667 views