Problem with INT when creating a table.

[falch006]

Here is my problem...

>CREATE TABLE int_test
>(
>number_one int(6)
>);
number_one int(6)
*
ERROR at line 3:
ORA-00907: missing right parenthesis

Always tells me I'm missing right parenthesis even though I've closed them all and I can't figure out why.

[Dave44]

Here is my problem...

>CREATE TABLE int_test
>(
>number_one int(6)
>);
number_one int(6)
*
ERROR at line 3:
ORA-00907: missing right parenthesis

Always tells me I'm missing right parenthesis even though I've closed them all and I can't figure out why.

I dont think you can declare a scale for datatype int.

[147]gab_dev@DEV01> create table t (number_one int);
 
Table created.
 
Elapsed: 00:00:00.21
[147]gab_dev@DEV01> insert into t values (111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111);
 
1 row created.
 
Elapsed: 00:00:00.04
 

[subashsavji]

Here is my problem...

>CREATE TABLE int_test
>(
>number_one int(6)
>);
number_one int(6)
*
ERROR at line 3:
ORA-00907: missing right parenthesis

Always tells me I'm missing right parenthesis even though I've closed them all and I can't figure out why.

create table a2 (a int);

[debasisdas]

Since Int is a sub-type of number you can't specify the (p,s) values .

By default INT=NUMBER(38).