17 responses

  1. Anonymous
    June 13, 2012

    Hi Jeff,
    Just want to share some finding. I can see that the color of the gauge behind the upper threshold may vary between green, yellow, and red. When the value is below 66, it is green. When the value is 66 or more but less than 90, that’s yellow. Otherwise (above 90) that’s red.
    Probably, you already know about it, and maybe there is a way to change those ‘fixed’ thresholds.
    Thanks.

    • thatjeffsmith
      thatjeffsmith
      June 13, 2012

      For the tablespace report? Yes, that sounds right, but let me see if I can’t get the source and share the code how to build that sort of gauge, versus the gauges I have in my examples.

      • Andrew Merton
        September 15, 2014

        Hi Jeff – Did you ever get the source code?

        Is there any way to build our own gauge and have it used by SQL Developer?

        I see a feature request to reverse the colours for SQLDEV:GAUGE was rejected back in 2008…

        IMO, a gauge like this shouldn’t have non-configurable thresholds set, not if it’s going to be useful to large numebrs of people…

        And yes, I see that it works well for the Manage Database report :)

  2. Ivan
    February 5, 2014

    Jeff, is there any way to store the definition of the reports on a server and have users access them using SQLDeveloper to have reports generated locally?

    • thatjeffsmith
      thatjeffsmith
      February 6, 2014

      Tools – Preferences – Database – User Defined Extensions

      Add a report entry for each of the reports you want to have shared – you can reference the file via http or via directory location.

      • Ivan
        March 3, 2014

        Jeff, it’s obvious the SQLDeveloper is a tool for developer, but most business customers today would like to have direct access to their data , BI is just icing on the cake. Most of those tools are either too costly, or take to much resources to maintain. If there’s a “light” version that developers can generate the XML files (pre-defined, param-driven reports) and can be executed as a stand-alone web application – just like Oracle XE’s web interface but with the SQLDeveloper report functionality, that would be awesome! :)

      • thatjeffsmith
        thatjeffsmith
        March 3, 2014

        It kinda sounds like you’re describing APEX.

  3. qpirsel
    March 26, 2014

    Hi Jeff,

    I like Oracles SQL Developer not at last because its free. But what I’m really missing is a qiuck option for linked queries when I select a row. For example PL/SQL Developer offers this feature (see http://www.allroundautomations.com/download/Manual71.pdf / 6.4). Do you have a hint how to realize something similar in Oracles product?

    • thatjeffsmith
      thatjeffsmith
      March 26, 2014

      No way to auto browser master-child records from a query resultset. We’ve talked about building something like into the table editors, but it’s still on the drawing board. We have this, but it’s not really what you’re asking for – useful for reports though.

  4. qpirsel
    March 27, 2014

    Thank you for the quick reply. It’s a pity that OSD doesn’t offer this.

  5. Enrico
    November 5, 2014

    hi Jeff,
    I want use “SQLDEV:LINK”, bau the objects are datafile. How to make?
    Thanks

  6. Enrico
    November 12, 2014

    hi Jeff,
    I want use “SQLDEV:LINK” with object like tablespace too.
    How to make?
    Thank you,
    Enrico

    • thatjeffsmith
      thatjeffsmith
      November 12, 2014

      Turns out you CAN do this :)

      Here’s all the object links possible from the DBA panel.

      ‘SQLDEV:LINK:’||USER||':SCHEDULED_RMAN_ACTION:’||JOB_NAME||':oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’ as “Job Name”,
      ‘SQLDEV:LINK{#;#}’||USER||’#;#BACKUP_JOB#;#’||command_id||’#;#oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’ as “Backup Name”,
      ‘SQLDEV:LINK:’||USER||':BACKUP_SET:#’||F.BS_KEY||':oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’ as “Key”,
      ‘SQLDEV:LINK:’||USER||':CONSUMERGROUP:’||consumer_group||':oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’ as “Consumer Group”,
      ‘SQLDEV:LINK:’||USER||':CONSUMERGROUPMAPPING:’||P.ATTRIBUTE||':oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’
      ‘SQLDEV:LINK:’||USER||':CONTAINERRMPLAN:’||p.plan||':oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’ as “Plan”,
      ‘SQLDEV:LINK{#;#}’||USER||’#;#CONTROLFILE#;#’||c.name||’#;#oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’ as “File Path”,
      ‘SQLDEV:LINK{#;#}’||USER||’#;#DATAFILE#;#’||ddf.file_name||’#;#oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’ as “File Name”,
      ‘SQLDEV:LINK{#;#}’||USER||’#;#IMAGE_COPY#;#’||FNAME||’#;#oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’ as “Name”,
      ‘SQLDEV:LINK{#;#}’||USER||’#;#PERFORMANCE_ADDMTASK#;#’||a.task_name||’#;#oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’ as “Name”, ‘SQLDEV:LINK{#;#}’||USER||’#;#PERFORMANCE_BASELINE#;#’||b.baseline_name||’#;#oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’ as “Name”,
      ‘SQLDEV:LINK{#;#}’||USER||’#;#PERFORMANCE_BASELINE#;#’||b.baseline_name||’#;#oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’ as “Name”,
      ‘SQLDEV:LINK{#;#}’||USER||’#;#PERFORMANCE_BASELINETEMPLATE#;#’||t.template_name||’#;#oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’ as “Name”,
      ‘SQLDEV:LINK{#;#}’||USER||’#;#PERFORMANCE_BASELINETEMPLATE#;#’||t.template_name||’#;#oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’ as “Name”,
      ‘SQLDEV:LINK{#;#}’||USER||’#;#PERFORMANCE_SNAPSHOT#;#’||sn.snap_id||’#;#oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’ as “ID”,
      ‘SQLDEV:LINK{#;#}’||USER||’#;#PERFORMANCE_SNAPSHOT#;#’||sn.snap_id||’#;#oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’ as “ID”,
      ‘SQLDEV:LINK{#;#}’||USER||’#;#PERFORMANCE_ADDMTASK#;#’||f.task_name||’#;#oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’ as “Task Name”,
      ‘SQLDEV:LINK:’||USER||':PROFILE:’||p1.profile||':oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’ as “Profile”,
      ‘SQLDEV:LINK:’||USER||':REDOLOGGROUP:#’||group#||':oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’ as “Group”,
      ‘SQLDEV:LINK:’||USER||':RESOURCEMANAGERPLAN:’||p.plan||':oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’ as “Plan”,
      ‘SQLDEV:LINK:’||USER||':RESOURCEMANAGERPLAN:’||p.plan||':oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’ as “Plan”,
      ‘SQLDEV:LINK:’||USER||':RESTORE_POINT:’||name||':oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’ as “Restore Point Name”,
      ‘SQLDEV:LINK:’||USER||':RESTORE_POINT:’||name||':oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’ as “Restore Point Name”,
      ‘SQLDEV:LINK:’||USER||':ROLE:’||role||':oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’ as “Role”,
      ‘SQLDEV:LINK{#;#}’||USER||’#;#ROLLBACK_SEGMENT#;#’||r.segment_name||’#;#oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’ as “Name”,
      ‘SQLDEV:LINK:’||USER||':TABLESPACE:’||a.tablespace_name||':oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’ as tablespace_name,
      ‘SQLDEV:LINK:’||USER||':TABLESPACE:’||h.tablespace_name||':oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’ as tablespace_name,
      ‘SQLDEV:LINK:’||USER||':TABLESPACE:’||g.tablespace_name||':oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’ as “Tablespace” ,
      ‘SQLDEV:LINK:’||USER||':TT_GROUPS:’||group_name||':oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’ as “Group”
      ‘SQLDEV:LINK:’||USER||':USER:’||USERNAME||':oracle.dbtools.raptor.dba.navigator.Drill.DBADrillLink’ as “User Name”

      • Enrico
        November 18, 2014

        Great, Thank you!!!

  7. Gustavo Chinaglia
    March 17, 2015

    Hello Jeff,

    Is possible to change the background color of some result on SQL DEVELOPER ?

    Something like that ?

    CASE
    WHEN column = ‘valor’ THEN ‘setBackgroundColor = red’
    END

    Thank you very much !

    • thatjeffsmith
      thatjeffsmith
      March 17, 2015

      But of course!

      • Gustavo Chinaglia
        March 17, 2015

        Thank You !

Leave a Reply

 

 

 

Back to top
mobile desktop