Wonder if there any oracle sql expert around ?
Like to ask one query regarding adding in a new column in a table
I know the command is something like
eg. ALTER TABLE <table_name> ADD <column_name> NUMBER(5) NULL;
When i perform a
SELECT * FROM USER_TAB_COLUMNS WHERE TABLE_NAME LIKE '<table_name>'
I noticed there are quite a number of other fields (in bold below) for that new column which is not filled up.
Wonder how do I go about modifying them ? :dunno: Thanks in advance ! :lovegrin:
TABLE_NAME COLUMN_NAME DATA_TYPE DAT DATA_TYPE_OWNER DATA_LENGTH DATA_PRECISION DATA_SCALE N COLUMN_ID DEFAULT_LENGTH DATA_DEFAULT NUM_DISTINCT LOW_VALUE HIGH_VALUE DENSITY NUM_NULLS NUM_BUCKETS LAST_ANAL SAMPLE_SIZE CHARACTER_SET_NAME CHAR_COL_DECL_LENGTH GLO USE AVG_COL_LEN CHAR_LENGTH C V80 DAT
------------------------------ ------------------------------ ---------------------------------------------------------------------------------------------------------- --- ------------------------------ ----------- -------------- ---------- - ---------- -------------- -------------------------------------------------------------------------------- ------------ ---------------------------------------------------------------- ---------------------------------------------------------------- ---------- ---------- ----------- --------- ----------- -------------------------------------------- -------------------- --- --- ----------- ----------- - --- ---
Like to ask one query regarding adding in a new column in a table
I know the command is something like
eg. ALTER TABLE <table_name> ADD <column_name> NUMBER(5) NULL;
When i perform a
SELECT * FROM USER_TAB_COLUMNS WHERE TABLE_NAME LIKE '<table_name>'
I noticed there are quite a number of other fields (in bold below) for that new column which is not filled up.
Wonder how do I go about modifying them ? :dunno: Thanks in advance ! :lovegrin:
TABLE_NAME COLUMN_NAME DATA_TYPE DAT DATA_TYPE_OWNER DATA_LENGTH DATA_PRECISION DATA_SCALE N COLUMN_ID DEFAULT_LENGTH DATA_DEFAULT NUM_DISTINCT LOW_VALUE HIGH_VALUE DENSITY NUM_NULLS NUM_BUCKETS LAST_ANAL SAMPLE_SIZE CHARACTER_SET_NAME CHAR_COL_DECL_LENGTH GLO USE AVG_COL_LEN CHAR_LENGTH C V80 DAT
------------------------------ ------------------------------ ---------------------------------------------------------------------------------------------------------- --- ------------------------------ ----------- -------------- ---------- - ---------- -------------- -------------------------------------------------------------------------------- ------------ ---------------------------------------------------------------- ---------------------------------------------------------------- ---------- ---------- ----------- --------- ----------- -------------------------------------------- -------------------- --- --- ----------- ----------- - --- ---