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

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

@JeffSmiththat

7 жыл бұрын

where would this list of values come from?

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

6 жыл бұрын

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

@jig1056

6 жыл бұрын

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

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

5 жыл бұрын

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

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

4 жыл бұрын

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'

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

6 жыл бұрын

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

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

2 жыл бұрын

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

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

6 жыл бұрын

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/

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

6 жыл бұрын

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

@doesnt_even_lift

6 жыл бұрын

Thanks, all your resources have been amazing so far

@JeffSmiththat

6 жыл бұрын

Here's that video you 'requested' ;) kzread.info/dash/bejne/kXWos8R-fqWpdZM.html

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

6 жыл бұрын

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

6 жыл бұрын

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

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

@JeffSmiththat

2 жыл бұрын

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

Auto-search is absolutely my favorite

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

@JeffSmiththat

4 жыл бұрын

Which theme?

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

4 жыл бұрын

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

4 жыл бұрын

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

@JeffSmiththat

4 жыл бұрын

@@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

4 жыл бұрын

@@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

4 жыл бұрын

@@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.

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

@JeffSmiththat

7 жыл бұрын

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

@SCLibi

7 жыл бұрын

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

@SCLibi

7 жыл бұрын

The bug still exists in version 17.2.0.188

@JeffSmiththat

7 жыл бұрын

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

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

4 жыл бұрын

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

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

@JeffSmiththat

4 жыл бұрын

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

4 жыл бұрын

@@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

4 жыл бұрын

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

@JeffSmiththat

4 жыл бұрын

@@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

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!

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

@JeffSmiththat

7 жыл бұрын

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

@SCLibi

7 жыл бұрын

i'll wait another 3 months patiently

You're missing "My nama Jeff""

@JeffSmiththat

5 жыл бұрын

??

@pdadsoetta4709

5 жыл бұрын

@@JeffSmiththat kzread.info/dash/bejne/c5p9saSFopS0dLg.html

Use vscode

@JeffSmiththat

5 жыл бұрын

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

@daniloamorim3012

5 жыл бұрын

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

@JeffSmiththat

5 жыл бұрын

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

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.