I said there were 8 ways to avoid using SELECT * FROM queries in SQL Developer – but I didn’t actually count them. So let’s do that now. @MarkusHohloch @tobias_arnhold there's about 8 ways to get columns to your query — OracleSQLDeveloper (@OracleSQLDev) November 23, 2016 But wait, what’s wrong with SELECT * FROM queries? you don’t need all the …
Case Closed: lower, InitCAP, UPPER, And Stuff
Best practice for code readability dictates that your keywords should always be in: insert your preferred style here __________. Here’s a Twitter poll I’m running if you want to personally weigh in: Do you agree? Best coding practices dictate uppercase identifiers? https://t.co/WhOZvL2Bmv — Jeff Smith ☜ (@thatjeffsmith) March 16, 2016 So even if we can’t all agree on what’s best, …
Get Help, Just Hit TAB
You’re at the command-line, you need to add a data file to your tablespace. You get most of the way through it, and you forget what’s next, doh! In SQLcl, you can just hit the TAB key, and we’ll help you with the next keyword. So not only do we have tab-completion for object and column names, we also look …
Quick Tip: PLSQL Variable Suggestions
I should have known this, but apparently we offer you up a list of your variables when working in the PL/SQL code editor. It even identifies my string and number variables as such. 42 words, so this is definitely a QUICK TIP.
Continued Improvements to [Code] Completion Insight
A few weeks ago I published a story highlighting all of the different ways SQL Developer can help you with your code. That post generated a lively discussion around this: Pre Version 4.1 Let’s try that again: Version 4.1 Early Adopter 2, specifically We’re also making sure to sort the local schema objects ALWAYS to the top of the pick …
Oracle SQL Developer: The Definitive Guide to Completion Insight
Can SQL Developer help me finish my SQL or code? Probably. Here’s a quick showing of what it’s capable of. Need more help on the syntax? Click on the keyword in the last two examples, and you’ll be taken to Oracle DOCS syntax pages for that command. Update: I Found One More! Not working? A few things to remember: mind …
30 SQL Developer Tips in 30 Days, Day 1: Help with WHERE Clauses
For the month of September I’m challenging myself to perform two different feats of strength: Do 5,000 push-ups in the month of September Post a SQL Developer Tip or Trick every day for the next 30 days I’ve noticed my posts are starting to go out once or twice a week, and I like to average three. So hopefully this …
Oracle SQL Developer Code Insight Syntax Examples
There really are times your tool is smarter than you are. Thank you #SQLDev Code Insight for listing syntax examples. @thatjeffsmith — Amy Caldwell (@amyccaldwell) August 7, 2014 In fairness to Amy, I don’t think SQL Developer is ‘smarter.’ I think it just has faster access to the Oracle Docs than she does. And SQL Developer won’t ask for help. …
Video: Completion Insight in Oracle SQL Developer v4.0.2
I said earlier today that version 4.0.2 of SQL Developer consisted on ONLY bug fixes. I should have said MOSTLY bug fixes. There was also one minor tweak, although it was a minor tweak to a major feature: Completion Insight. This is the feature that kicks in while you are typing – suggesting column or table names to help you …
Four Oracle SQL Developer Preferences You Should Know
In an earlier blog post I listed my ‘Top 10 Preferences to Tweak…’ Instead of amending that to Top 14, I wanted to give a fresh and updated take on some features that directly impact productivity and data quality. After doing three customer calls in three consecutive days, I realized I was spending a lot of time on these preferences …