@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
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...
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!
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.
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
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.
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 😎🏖️
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
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
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!!!
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'
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.
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
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?
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
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
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.
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/
@@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.
@@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.
@@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.
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.
@@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 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
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.