Oracle SQL Developer: You're Doing it Wrong

[@harrybuckley7292]

Hi Jeff Smith, thanks for the video. I collect and read the mails you send out so thanks for those also. Regards Harry (UK).

[@braykov]

Auto-search is absolutely my favorite

[@bogov6762]

The biggest frustration I have with Sql Developer are: 1: shortcuts do not work (Last edit code for example) or the possibility to work in a Full screen editor without the Script Output. Now I have to click on the 2 black arrows. 2: code insight. If you have ever worked with e.g. IDEA or Eclipse then you immediately understand what I mean. Even activating a template with Ctrl-Space does not work. This video is from 5 years ago; I am using version 22. It just doenst do what a 2023 editor should do. But I am still using it because it has many cool feautures!! The editor is just outdated...

[@JeffSmiththat]

Code Templates activations with ctrl+space is working for me, no known bugs there. However, code insight in general has SEVERAL bugs which will be fixed in version 23.1 - hopefully out in several weeks. I agree the editor is outdated. That's why we're building a next generation SQL Developer based on VS Codium. That will launch as a v1, early Spring 2023!

[@bogov6762]

@@JeffSmiththat I am very much looking forward to this! This is great news. Thanks for the update!

[@ikacherful]

I've been looking everywhere for this answer and I am sure it is possible to do so: How do you open a table in a new tab in Oracle SQL Developer? Thank you.

[@JeffSmiththat]

ilooshinka I assume you mean how to open a table without closing one you already have open. Use the push-pin button on the object toolbar. When you open another table, the first one won't go away. If you want to see both at the same time, right click on the second table tab and select New Document Tab Group. I hope this helps! -Jeff from the beach 😎🏖️

[@ikacherful]

Ahhh. Thank you very much for the very quick answer, Jeff. Have fun at the beach dude!!

[@DavidJaime]

Hello Jeff, How can I 'select' a value from a LOV for a column in the Data Tab? Thanks

[@JeffSmiththat]

where would this list of values come from?

[@jig1056]

Jeff thanks for making this video I learned a few cool things. I do have a question that I can't seem to find on my own... Is it possible to directly edit the returned records in a grid? For example, I return 10 rows from an address table in my DEV database, I want to directly change the state on one of the records from NY to NJ can I do that? Basicly i want to make the grid editable

[@JeffSmiththat]

Mark Nelson no, you'll need to use an update statement or use the table editor for a live grid

[@jig1056]

That's exactly what I didn't want to hear :) Hope that is a feature that is added in a future update but I really appreciate taking the time to let me know... Thanks

[@lstewart19]

I have been unable to get the brackets in the SQL Editor Code Template result in the query window automatically highlighting that section of text (the one contained in the [ ] ). You talk about this ~11:39 in the video. I am on version 17.2.0.188. Love your videos and posts - thanks for sharing.

[@JeffSmiththat]

It doesn't work with auto replace enabled, so make sure that's not checked. Thanks for the kind words and feedback!

[@useyername]

Really helpful, concise video! You mentioned that you had a whole talk on reports, but I couldn't find it in on your channel, any chance it's recorded somewhere?

[@JeffSmiththat]

Ian K so I have a talk, not sure it's ever been recorded. But I have slides www.slideshare.net/hillbillyToad/all-about-oracle-sql-developer-and-reporting

[@useyername]

Thanks, all your resources have been amazing so far

[@JeffSmiththat]

Here's that video you 'requested' ;) kzbin.info/www/bejne/lXLXgpV7g6d2e5I

[@olgazimnyakova9638]

Also, if you provide paid help, I’d like to use your extensive knowledge. The only problem how to show what is on my laptop coz it is company data? O.K. I might be at home but you can’t connect to my computer. Shall I do it via Skype camera as one guy suggested but it did not work. I will use PayPal fro payments; only need add cash to PayPal card.

[@JeffSmiththat]

So sorry Olga, I'm not setup to do paid consulting.

[@olgazimnyakova9638]

Hi, Jeff! I have a question. I have 2 tables many columns; need to run variance between 2 columns Sum; Left JOIN columns On Column B =Column A. In the results, column B have few lines, column A creates few matching lines. But! If the $amount is only $8000 in column A, it puts $8000 in few rows to match Column B. From the Variance standpoint, I got wrong variance. How to roll up only values in column B; this way thy total $8000 to column A? Also, drives me crazy all the combinations in Group By and Rollup. I just need to make sure the above. Thank you very much!!!

[@JeffSmiththat]

If you can post your question on Stackoverflow, making sure to provide a description of both tables, the exact SQL you're looking for, and the answer you're getting vs what you are expecting, i'd be happy to take a look. Tag your question with 'oracle' and 'sql'

[@darshankhatri9625]

Hi Jeff, How to increase the GUI of SQL developer , its appearing very microscopic . How to change its size?

[@JeffSmiththat]

You can find some ideas/suggestions here stackoverflow.com/questions/50138830/how-to-increase-size-of-gui-font-everything-of-oracle-sql-developer-18-1/50139062#50139062

[@dmitryoleynik3710]

@JeffSmiththat Hi Jeff, Could you write a link to regular expression version used in SQL Develop? I mean just Search and Search and Replace in Editor. I'm tired to find something worth

[@JeffSmiththat]

When you open the find/replace dialog, on the toolbar is a button that looks like .* Toggle that 'on' - and then you can use regular expressions

[@shakunsood]

Hi Jeff, Do we have an option to add bulk autoreplace data? For example, if I have 100s of table names, I can just add first three letters of the table while writing a query and Oracle SQL Developer automatically completes the table name for me?ThanksShakun

[@JeffSmiththat]

shakun sood yes, Ctrl spacebar to invoke code helper, auto complete is default behavior though

[@thomasfamily3762]

Hey Jeff, when are you guys going to program in the ability to change a password that is about to expire (in the grace period)? I swear I'm sick of having to change developers passwords because it's in the grace period and they can't log into sql developer.

[@JeffSmiththat]

it's there, just right-click on the connection 'reset password', or if you have a connection going, type 'password' and run that www.thatjeffsmith.com/archive/2017/01/password-resets-no-longer-require-a-thick-connection-oracle-client-in-sql-developer/

[@ljosf]

Hi Jeff, how do I add new fonts to Sql developer? I would like to add Input or Droid sans as the default font. Using v 19.x.x I did install the font in windows and I can use the font in all the apps (word, excel) however I can't see the font in SQL Developer

[@JeffSmiththat]

make sure you add/install the font as the administrator user on your windows machine

[@FelipeNiclvs.]

when i install a theme sqldeveloper re writes the xml file for some reason

[@JeffSmiththat]

Which theme?

[@hyper8547]

Hi Jeff, I have installed the font on my Windows, but I can't find when inside font settings in SQL developer dropdown list for font

[@JeffSmiththat]

are you an administrator on your machine? and what font exactly did you add? i can try to do the same on my Windows 10 machine

[@hyper8547]

@@JeffSmiththat thx for replying, yes I am an administrator on my machine, I try to add the same font that you are using.

[@JeffSmiththat]

@@hyper8547 Sorry, I cannot explain what is causing this not to work for you. I would say please make sure you're using a newer, Oracle Java 8 JDK or maybe try Oracle Java 11 JDK instead.

[@hyper8547]

@@JeffSmiththat Hi Jeff, no need to say srr. Thx for taking your time in simplifying complex DB topics, I am actually using all the above- mentioned details versions. I have managed to change to the dark mode by applying the XML file, but for some weird reason, the droid font is not willing to show up.

[@abruenin236]

@@hyper8547 Same here. I installed the same Droid Sans Mono font and can use it with any other Windows Editor I tried. But SQLDev does not show it in the select list.

[@SCLibi]

we can't copy paste from tables on connections, we could in last version

[@JeffSmiththat]

Yup, I logged that as a bug. You can drag and drop to a worksheet as a workaround

[@SCLibi]

thanks... funny how something so simple can disrupt your workflow

[@SCLibi]

The bug still exists in version 17.2.0.188

[@JeffSmiththat]

Yeah, I never said it was fixed. I keep harping on the devs though.

[@marceloosorio525]

1.- It is reported a bug which the SqlDev is not able to store the passwords?

[@JeffSmiththat]

No, but I think I know what's happening. We increased our password encryption protection... It requires a newer Java. Make sure you have Java8 update 200 or higher to be safe.

[@marceloosorio525]

@@JeffSmiththat Thanks for answering...!!! By The way did you know how to control time session to azure?, our developer are being disconnected each 2 minutes!!! It is very ...%&$&%%%$, We asked to Azure... they said that probably is a "tool setup..." :-(

[@marceloosorio525]

@@JeffSmiththat MacBookMok:~ marcelo$ java -version java version "1.8.0_131"

[@JeffSmiththat]

@@marceloosorio525 yeah, you need u152 or higher i think to have the newer encryption jars available, if you're going to upgrade your java, get an update 200 or better as for Azure, no idea what MSFT is telling you. If the session is dying at 2 minutes, it's most likely a network configuration OR your db has a resource consumer group/plan in play that's limiting active time to 2 minutes

[@cakeman58]

I'd so love it if the selected font would end up in exported spreadsheets. God I hate Calibri!

[@JeffSmiththat]

if the apache library we use supports that I can look into it

[@SCLibi]

i'll wait another 3 months patiently

[@pdadsoetta4709]

You're missing "My nama Jeff""

[@JeffSmiththat]

??

[@pdadsoetta4709]

@@JeffSmiththat kzbin.info/www/bejne/d5esgHWCp5aBerc

[@daniloamorim3012]

Use vscode

[@JeffSmiththat]

We're building an Oracle extension for vs code so you can have your cake and eat it too

[@daniloamorim3012]

There is already good extensions for pl/sql, but there is no debug.

[@JeffSmiththat]

@@daniloamorim3012 I've seen the Oracle extension available, we will do MUCH better than that. twitter.com/krisrice/status/1097172457524510720

[@bonjovi7120]

Rather pay money and get Toad cause SQL Developer is a joke

[@JeffSmiththat]

That's your choice, of course. And you have many, many choices. I'm here to help the folks that want it. If you're happy working with oracle database, that's our biggest goal.