Oracle SQL Developer: You're Doing it Wrong

15 minutes power tips and tricks session where the product manager will how you how you SHOULD be using Oracle's database IDE and GUI.

[harrybuckley]

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

[dmitryoleynik]

@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

[bogov]

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

[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?

[darshankhatri]

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

[jig]

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

[DavidJaime]

Hello Jeff,

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

Thanks

[lstewart]

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.

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

[olgazimnyakova]

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

[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

[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

[olgazimnyakova]

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.

[hyper]

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

[thomasfamily]

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.

[FelipeNiclvs.]

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

[marceloosorio]

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

[SCLibi]

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

[pdadsoetta]

You're missing "My nama Jeff""

[cakeman]

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