Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2011
    Posts
    25

    Unanswered: Illegal use of LONG datatype,When Use Distinct in Select Statement.

    Select DISTINCT UCOL.TABLE_NAME,UCOL.COLUMN_NAME , UCOL.DATA_TYPE , UCOL.DATA_LENGTH ,UCOL.DATA_PRECISION,
    UCOL.DATA_LENGTH || CASE WHEN UCOL.DATA_PRECISION IS NULL THEN '' ELSE ','||UCOL.DATA_PRECISION END DATA_SIZE_PRECISION
    , UCOL.DATA_DEFAULT , COM.COMMENTS
    from user_tab_columns UCOL
    LEFT JOIN USER_COL_COMMENTS COM
    ON UCOL.TABLE_NAME = COM.TABLE_NAME
    AND UCOL.COLUMN_NAME = UCOL.COLUMN_NAME
    ORDER BY UCOL.TABLE_NAME,UCOL.COLUMN_NAME;


    This is not Work When Use Disctinct keyword in the Statement.

    Thanks in Advance.

  2. #2
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    AND UCOL.COLUMN_NAME = UCOL.COLUMN_NAME
    Is it "AND UCOL.COLUMN_NAME = COM.COLUMN_NAME"?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •