5 Replies Latest reply: Jul 24, 2012 9:40 AM by dvsoukup RSS

    SQL Developer: Right-click > format doesn't work right with DATE datatype

    dvsoukup
      Hi All!

      Currently I'm using version SQL Developer Version 3.1.05.

      Got a question regarding the 'auto-format' of syntax whenever writing in the code editor.

      If you take this snippet of code and drop it into a worksheet, then highlight it, right click the mouse, then select "format" it's like it fails to add the proper spacing when it runs into the DATE datatype. I looked all through the : preferences > database > sql formatter > oracle formatting > edit and couldn't find anything regarding the formatting with date types.

      Am I looking in the wrong area?? Is this a known bug? Having trouble searching for this exact issue too. I LOVE the format feature, but I hate having to go to each date type and manually spacing it out to make everything look 'clean'. I'm picky I guess :P I can live with it but figured I'd ask.

      type TEMP_REC
      IS
      record
      (
      ORG_CODE VARCHAR2(15),
      PROJECT VARCHAR2(15),
      WBS VARCHAR2(30),
      SERIAL_NO VARCHAR2(30),
      QTY_ORDERED NUMBER,
      QTY_SCRAPPED NUMBER,
      QTY_COMPLETE NUMBER,
      BOM_ID NUMBER,
      REQUEST_DATE DATE,
      CREATE_DATE DATE,
      REL_DATE DATE,
      START_DATE DATE,
      NEED_DATE DATE,
      DUE_DATE DATE,
      COMPLETE_DATE DATE,
      CREATED_BY VARCHAR2(30),
      MODIFIED_BY VARCHAR2(30),
      MODIFY_DATE DATE,
      EST_HOURS NUMBER(6,2),
      ACT_HOURS NUMBER(6,2),
      BAD_COMMENTS VARCHAR2(1000) );