Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help with SQL statement and SUBSTR

Re: Help with SQL statement and SUBSTR

From: <norcold1_at_yahoo.com>
Date: 30 Sep 2005 09:18:04 -0700
Message-ID: <1128097084.896138.153580@o13g2000cwo.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US