38 responses

  1. Meghan
    April 17, 2013

    Hi Jeff,

    Thanks for your presentation, I picked up several great tips that I’m already using. I was the one who submitted a question about the PL/SQL editor background color. What I meant is, are there plans to allow the background color to be fully customizable, where a user can set it to ANY color they want? The reason I ask is that I prefer my editor background color to be off-white or light yellow (since it’s been shown to be the best for preventing eye strain), but this option is not included any any of the predefined themes. It’s a pretty common feature in an IDE to allow the user to do whatever they want with their editor colors, which is why it’s surprising that the most SQL Developer offers is pre-defined themes with no option to set your own background color. I know this is nit-picky, but really, it’s one of my top pet peeves about the program.

    Thanks,
    Meghan

    • thatjeffsmith
      thatjeffsmith
      April 17, 2013

      I’m confusesd Meghan – you can change it to any color you want. You can override any color provided by the Scheme if you want.

      • Meghan
        April 17, 2013

        Thanks for your quick response. Maybe I’m missing something here, or maybe my configuration is wonky, but I have never in 2 years been able to fully change the background color of the editor.

        Here are the steps I follow: Tools –> Preferences –> Code Editor –> PL/SQL Syntax Colors. Choose a Schema from the drop-down (say, Classic with a blue background). Choose a different color from the Background palette, and hit OK. The only parts of the code that actually have my chosen background color are the comments; the rest of the editor window still has a blue background.

        Am I doing something wrong? I’ve tried playing around the background color option under all of the things listed under “Available Styles”, but no dice.

      • thatjeffsmith
        thatjeffsmith
        April 17, 2013

        I see what you mean now – I thought there was a ‘default’ item in that list box, but there’s not. Talking to some developers friends to see how to do this. I agree with you, it should be there.

      • Meghan
        April 18, 2013

        Thank you so much. If this could be added, it would make me so happy :)

      • thatjeffsmith
        thatjeffsmith
        April 18, 2013

        developer found the issue, it’s FIXED for next version – so stay tuned :)

      • Learco Brizzi
        June 20, 2013

        Hi Jeff,

        Why isn’t it possible to do the same in SQL Developer as in SQL Developer Data Modeler concerning the PL/SQL formatting and color? In the Modeler you don’t have that much options.

        Learco

      • thatjeffsmith
        thatjeffsmith
        June 20, 2013

        Learco,

        I need more details. Are you saying you’re wanting PL/SQL Formatting colors to apply to the DDL generated in the Modeler in the DDL preview dialogs?

        Jeff

      • Learco Brizzi
        June 21, 2013

        Hi Jeff,

        Thanks for your answer. Let me explain a little bit more on that. In the physical model you have the possibility to create packages and triggers.
        When creating a package, it looks the same as in SQL Developer, but you can’t compile and do other stuff of course. But the formatting options are not the same, especially the fonts and colors are not adjustable. Another difference is the ability to see the individual functions and procedures of the package in the ‘tree’ in the left pane. In SQL Developer you can and in SQL Developer Data Modeler there is’n a way to see them.
        For trigger there’s a different editor, why not using the same?

        Maybe I’m missing things as I’m just beginning to use the Modeler as a replacement for Designer.

        Thanks for your time,
        Learco

    • thatjeffsmith
      thatjeffsmith
      April 17, 2013

      Also, thanks for the feedback and questions! I’ll do my best to get the editor looking the way you need it to!

      • Rob
        January 15, 2014

        Hi Jeff. You mentioned above that the background colour change issue was fixed for the next version in April 2013. I am on version 3.2.20.09 and still don’t appear to be able to change the overall background colour. Was this fix ever released please?

        Thanks.

      • thatjeffsmith
        thatjeffsmith
        January 15, 2014

        The next version from April 2013 would be version 4.0 :) In version 4, set the ‘scheme’ to default, and then set Background to Black, or whatever floats your boat.

      • Rob
        January 20, 2014

        Got it Jeff, that’s great thanks :)

  2. Panagiotis Katsoulis
    April 18, 2013

    Thank you for your presentation.
    I wonder if there is an option not to auto-query table when opening Data tab, but only when you press refresh.

    • thatjeffsmith
      thatjeffsmith
      April 18, 2013

      So I’m thinking, if you don’t want the query to execute, don’t click on the data tab?

      • Panagiotis Katsoulis
        April 18, 2013

        why not enter your where criteria before….??

      • thatjeffsmith
        thatjeffsmith
        April 18, 2013

        So it’s taking a long time for the data to come back? And you want to avoid that by using a WHERE clause filter?

        Are you just browsing, or will you be editing the data as well?

      • Panagiotis Katsoulis
        April 18, 2013

        It depends, it takes some time occasionally and it might be useful as an option.

      • thatjeffsmith
        thatjeffsmith
        April 18, 2013

        you should be able to cancel the initial fetch if it takes too long…also you can always just run a SELECT * FROM…WHERE in a worksheet if you just want to browse the data. Just drag the table to the worksheet, that will help you build your query, then you can execute when you’re ready.

  3. Panagiotis Katsoulis
    April 18, 2013

    there is no cancel button in the table data tab like the one appears in the worksheet on execution, so cancel isn’t an option too..

    thank your for your time

  4. PPS
    April 24, 2013

    Hi Jeff,

    Is there any way to edit data in worksheet it self if we use
    for update or select rowid.

    Many Thanks,
    PPS

    • thatjeffsmith
      thatjeffsmith
      April 25, 2013

      Grids in the worksheet are READ ONLY – but if you have the ROWID you could ctrl-click into the table from your query, use the ROWID as a FILTER in the table editor, and get to that row fairly quickly.

  5. Patty Delmott
    April 29, 2013

    Jeff,

    In SQL Developer (3.2.09), I will be logged into PROD, using query builder, then want to test in PPRD (which I’m not logged in to). So I click the database icon in the upper right corner from PROD to PPRD, and it kills me every time. By that, I mean, I get the Connection Information box, my user name is there, but I am not allowed to enter text into the password box or click the Cancel or Help buttons. The only way to get out of this is to kill my session.

    Am I doing something wrong or is this a bug that could be fixed? I can log into PPRD several different ways, only this way causes me to kill my session.

    Thanks!

    Patty

    • thatjeffsmith
      thatjeffsmith
      April 29, 2013

      I’m guessing, you don’t have the password for that connection saved, yes?

      • Patty Delmott
        April 29, 2013

        Nope, I type it each time.

      • thatjeffsmith
        thatjeffsmith
        April 29, 2013

        “..I am not allowed to enter text into the password box..” – the dialog is completely inaccessible? Or can you type into the USER piece?

        Weird either way…I tried this and it seems to work for me.

        What OS and version of Java do you have installed?

        Also, as a workaround, if you save your password for the PPRD, does it ‘work?’

      • Patty Delmott
        April 30, 2013

        Sorry, got busy.

        I have Oracle 10g and 11g using TNS; Java 6 Update 37 (not going to Java 7 yet).

        I can’t type anything in the box, not even my username, but my username did show up.

        If I save my password, all is well, not box comes up and I am automatically changed from PROD to PPRD.

        Thanks for you help!

        Patty

  6. Rose Wilson
    May 3, 2013

    I run SQL Developer on Windows 7. When I use the F8 key, in a SQL Worksheet window, it does not bring up my SQL History. When I do this: cd %appdata%\SQL Developer\, I do see History xml files.

    • thatjeffsmith
      thatjeffsmith
      May 3, 2013

      So in the next version, there will be a button in the menu system to reset your windowing layouts – which is what I’m suspecting you need to do to get the SQL History to appear. So for now, you need to do this

      Reset your windowing layout preferences. On my Windows 7 system, for the latest SQL Developer release, those are located in:
      C:\Users\\AppData\Roaming\SQL Developer\system3.2.20.09.87\o.ide.11.1.1.4.37.59.48\windowinglayout.xml
      Just exit SQL Developer, delete that file, then open SQL Developer again. You will need to open the Log and SQL History again from the Views menu.

  7. Mike
    June 15, 2013

    Hi Jeff,

    regarding your answer about disabling the SQL Monitor feature if you don’t have Diagnostic and Tuning Pack licenses, are you referring to the Licensing Preferences dialog in SQL Developer ?
    This setting isn’t entirely foolproof in all circumstances.
    I’m sure that you are aware of the issue with the ASH and AWR reports that come bundled with SQLDeveloper not being disabled by this feature.
    Are there any plans to tighten this up in future releases ?

    Thanks,

    Mike

    • thatjeffsmith
      thatjeffsmith
      June 15, 2013

      Hmmm, we do prompt/warn/force the user to acknowledge they’re accessing a Diagnostic Pack feature, and we tell you to manage the license config via the Preferences when accessing the ‘ASH REport For The Past 30 Minutes.’

      When I de-select ‘Diagnostic’ in Preferences and then try to run the report, I get an error message ‘Diagnostic Pack Required, blah, blah, blah.’ So in my opinion, the preference is working, we’ve prevented someone from running that report on a restricted database.

      I’m reading your bloggity-blog on the subject, and I’m confused. Are you saying if someone copies the SQL out of the report and runs it in the Worksheet that that’s our fault?

      Wouldn’t that be akin to blaming YOU if someone found that query on your blog and ran it on their database?

      Or maybe I’m not understanding the issue?

      What do you mean by ‘not being disabled by this feature’ exactly?

  8. Nicolas
    February 21, 2014

    Hi !

    Great post I am working with 4.0 at the moment!

    Quick question, is there a way to save the layout ? I use a lot of reports which I put in different panels (locks, free space, memory,etc) besides object explorer and it is really annoying to open everything up and arrange it every time.

  9. chandra shekhar
    June 26, 2014

    Hi Jeff,
    I am using 3.0.04, is there any way to validate the syntax for various DDLs queries without actually executing it?
    Actually, I have generated index file from a dump, but when I am running it, it is throwing error at a specific location saying inappropriate right parenthesis.
    Since the index file size is huge, around 4MB, I am not able to track the incorrect area visually.
    Thanks,

    • thatjeffsmith
      thatjeffsmith
      June 26, 2014

      We parse/validate the code as you type it/enter it into the editor. You have grammar problems highlighted with sqiggly red lines – just like you’d see in your word processor.

  10. Hugo
    August 20, 2014

    Hi jeff,

    Is there a setting in SQL Developer or on the Oracle Database to limit query time. I was having a query running for a while and my TI departement was little upset.

    Like if query run longer then XX minutes then return “process too long” or something like that. A delay task killer !!

    Thanks

    • thatjeffsmith
      thatjeffsmith
      August 20, 2014

      Not in the tool per-se, although I think there are jdbc timeout settings you could play with that might approximate the behavior you’re looking for. Your IT department should also look at resource consumer groups. They allow for a set of users to be given limits on CPU, memory, idle connection times, etc.

      Then again, if a query takes a really long time to run, sometimes that’s what it takes, yes?

  11. Federico
    August 20, 2014

    Hi Jeff.
    I need to congifure a Zebra GC420t printer on a PL/SQL Developer 10.0 server.
    Is this posible at all?

    • thatjeffsmith
      thatjeffsmith
      August 20, 2014

      I don’t know – you should probably go ask on the Allround Automations forum as they own PL/SQL Developer and not Oracle.

Leave a Reply

 

 

 

Back to top
mobile desktop