CREATE TABLE integer replaced by NUMBER(38)..
957127Aug 22 2012 — edited Aug 22 2012Hi,
I am using Oracle 11.1.0.6.O. Create a table using following query.
CREATE TABLE VENDOR_MASTER_new (
VENDOR_ID integer,
VENDOE_NAME VARCHAR2(50 CHAR),
STATUS smallint DEFAULT 1
)
Table Created.
check the table structure using DESC VENDOR_MASTER_new
It showing
SQL> desc vendor_master_new
Name Null? Type
----------------------------------------- -------- --------------------------
VENDOR_ID NUMBER(38)
VENDOE_NAME VARCHAR2(50 CHAR)
STATUS NUMBER(38)
SQL>
integer replaced by NUMBER(38)..
if it is possible to make integer. help me resolve this issue.