Recent content by TomSW

  1. T

    Describe table - table comment fills the screen(!) - resize or hide it to see columns?

    Hello, thanks for the quick reply! I think the tables were created with PowerDesigner. The DDL that adds the comment doesn't look special.
  2. T

    Describe table - table comment fills the screen(!) - resize or hide it to see columns?

    A colleague has a tendency to put very long comments on their tables and views, so long in fact that in the "Describe" dialog, the comment takes up the entire screen and the column list underneath is below the bottom edge of the screen. There are workarounds: I can use "View" table, but it's...
  3. T

    Edit materialized view from right-click in SQL window

    It works like that for me too. I have no idea how I got the idea that it didn't - sorry for the confusion! On the other hand - trying to salvage a valid topic - it would be neat to be able to right-click an MV in the Object Browser Table list and be able to switch the materialized view's...
  4. T

    Edit materialized view from right-click in SQL window

    When I right-click the name of a materialized view I get the option to "View" and "Edit" it, but these take me to the table behind the MV, and the the MV itself, so I can't see the query. Is there a way to get to the MV? I know I can edit the MV from the object browser, but when I am working...
  5. T

    Copy to Excel converts LF into CRLF?

    Thanks, it works! I was sure I'd tried this option, but it seems not.
  6. T

    Copy to Excel converts LF into CRLF?

    I have a query that returns CLOBs, that I split into 32767-character chunks in order to fit into Excel cells. And I was pleased with myself for discovering the REGEXP_SUBSTR on a CLOB will return a CLOB from an SQL query whereas SUBSTR and DBMS_LOB.SUBSTR won't. However, when I try and copy to...
See more
Back
Top