Database Administration (MOSC)

MOSC Banner

how much size of a column as identity?

edited Jul 12, 2017 5:00AM in Database Administration (MOSC) 1 commentAnswered

Hi everyone,

I'm using Oracle version 12.

Are there methods that we can know how much size of a column as identity ?

Bellow is the sample script where UNIQUE_NUMBER is made as IDENTITY

CREATE TABLE TEST

   ( UNIQUE_NUMBER NUMBER(10,0) INVISIBLE GENERATED BY DEFAULT AS IDENTITY ORDER NOT NULL ,

     Column_1 NCHAR(6) DEFAULT ' ',

     ...

     PRIMARY KEY (UNIQUE_NUMBER)

    )

Thank you so much,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center