oracle syntax

[Craig Jackson]

I am new to oracle and sql in general, I received an oracle create schema that needs to be converted using non-oracle syntax.

What does the following syntax mean?

line_status(1:20) char(2) null

Any information would be greatly appreciated.

Thanks.

[Martin Vajsar]

Post the whole command. Oracle's syntax is pretty rich and this excerpt doesn't look just right to me. You might also want to consult the documentation.

[Craig Jackson]

NUM_ACTION_CODES(1:5) char(20) NULL

create table x_COLL_CALL_STATS_REC (
       COMPANY_CODE char(1) NULL
     , OFFICE_NUM char(2) NULL
     , DEPT_NUM char(3) NULL
     , COLLECTOR_NUM char(4) NULL
     , CURR_YEAR char(4) NULL
     , CURR_MONTH char(2) NULL
     , WORK_TIME char(20) NULL
     , NUM_INBOUND_CALLS char(20) NULL
     , NUM_OUTBOUND_CALLS char(20) NULL
     , NUM_ACCTS_WORKED char(20) NULL
     , NUM_CONTACTS_MADE char(20) NULL
     , ACTION_CODE(1:5) char(2) NULL
     , NUM_ACTION_CODES(1:5) char(20) NULL
     , RESULT_CODE(1:5) char(2) NULL
     , NUM_RESULT_CODES(1:5) char(20) NULL
     , NUM_PROMISES char(20) NULL
     , AMT_PROMISED char(20) NULL
     , FILLER_22 char(22) NULL
     , COLL_CALL_STATS_WHOLE char(130) NULL
     , COLL_CALL_STATS_KEY char(16) NULL
     , DEPT_BREAK char(6) NULL
     , COLLECTOR_BREAK char(10) NULL
) ;

[Martin Vajsar]

I'm sorry, I won't be able to help. It is giving syntax error to me (version 10g) and I can't find anything like it in the documentation, not even in 11g.

Are you absolutely sure this was successfully run on Oracle sometime? As far as I know, all Oracle features are documented, even those that are optional, and I don't see place for parenthesized numbers delimited by colon between the column name and data type in any of the syntax diagrams.

[Christophe Verré]

It looks like some kind of check constraints (just guessing), but in Oracle the notation is different:

NUMBER CONSTRAINT ACTION_CODE CHECK (ACTION_CODE BETWEEN 1 AND 5)

I've never seen your notation.