Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help with SQL statement and SUBSTR
Thanks for the help...this is the output
CREATE TABLE SVC_CLAIM_HEADER
(
SEQ_CLAIM_ID NUMBER(9) NOT NULL, CLAIM_NUMBER VARCHAR2(16) NOT NULL, PRIMARY_SVC_DATE DATE NOT NULL, CLAIM_THRU_DATE DATE, SECONDARY_AUTH VARCHAR2(3), DATE_RECEIVED DATE, USER_DEFINED_1 VARCHAR2(15), USER_DEFINED_2 VARCHAR2(15), BATCH_NUMBER VARCHAR2(9), SECURITY_CODE CHAR(1) DEFAULT '0', INSERT_DATETIME DATE, INSERT_USER VARCHAR2(8), INSERT_PROCESS VARCHAR2(8), UPDATE_DATETIME DATE, UPDATE_USER VARCHAR2(8), UPDATE_PROCESS VARCHAR2(8),) Received on Fri Sep 30 2005 - 11:18:04 CDT