SQL.ProductManager.Oracle.Databases @thatjeffsmith Twitter profile

Pinned Tweet

SQL.ProductManager.Oracle.Databases

6 months

It's here! @OracleSQLDev extension for VS Code is now available! To get started, simply search for 'SQL Developer' in the VS Marketplace! Marketplace link Announcement Blog

39

92

224

Last Seen Profiles

@miff_india

@Coff33cak3

@Lynxgyu

@Narckez

@bl00dkys

@throbbinhoodof

@DANTEMJB

@looji151

@crispy_fluf

@staika_official

@cpagoku

@CoopTheRaccoon

@AkaashSingh

@SSYNDICATEALPHA

@AttentionToken

@HellCatsNFT

@PrepRedzoneIL

@SecretaryPete

@tKibJo5LT162847

@rubythecutie2

@WaedQbelat1

@Alexaartis

@jae_513

@NahuiLucatelli

@SyreeGlickm

@ishootboys

@ran__65x

@redbeardnft

@wakeupsamuray

@SACREDRUlN

@VmaniakJ

@elydentastic

@the_real_morra

@valeisje

@s7venwithyou

@dvrkfaith

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

3 years

Social Media Physics...one positive comment weighs 5x more than a negative one...or has more mass. Thoughts @neiltyson ?

9

2

228

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

3 years

News: Versions 21.4 of @OracleSQLDev and Data Modeler have been releases and are available for download. #oracle #sqldev These include Apache Log4j, version 2.15.0. Thanks to our product and release teams for the quick turnaround to address this issue!

13

55

175

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

2 years

TELL me you WRITE sql WITHOUT SAYING you WRITE sql;

77

11

168

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

7 years

I refer to this post more than any other - I Installed Oracle SQL Developer. Now what? #Oracle #Database #Beginner

I Installed Oracle SQL Developer, Now What?

You did it! You landed the big interview*. Tomorrow is the big day. There’s just one problem: they expect you to know what a database looks…

medium.com

26

42

155

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

2 years

I'm going to create a university class called 'Reading the actual Error Messages' - graduates can expect 6 figure digit salaries.

21

16

149

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

4 years

For the next 45 days, all OCI certifications and Oracle Autonomous Database certifications can be taken for free by anyone. #oracle #cloud #database #learn #earn

Oracle Ramps Up Free Online Learning and Certifications for Oracle Cloud Infrastructure and Oracle...

I’m happy to announce that Oracle is offering free access to online learning content and certifications for a broad array of users for Oracle Cloud Infrastructure and Oracle Autonomous Database.

www.oracle.com

2

84

137

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

1 year

Happy 24 years with this princess

15

0

140

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

5 years

20 years and counting

18

1

139

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

2 years

Somehow my employee got see this cool stuff before me... 🏎️

layla

@pilatesdev

2 years

I visited the Austin, TX @oracle campus today!! 🧡 Check it out:

39

22

923

3

1

119

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

2 years

So @oraclebase has a real job. And he produces content for his #1 #oracle resource site AND YouTube. And he replies to comments, question, and tweets. Let's not take this hero for granted, and instead give him a

6

21

117

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

1 year

My lovely partner in bourbon has a birthday today! She keeps me sane and grounded. We'll celebrate 24 years married in Barcelona in a few weeks!

14

0

104

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

3 years

Huge Announcement! We launched a new @OracleCloud Service - Database Tools! Check the post for a video walkthrough with @btspendo as well! #oracle #cloud #Developers #Database #100DaysofCode

4

54

97

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

2 years

Release announcement for @OracleSQLDev and Data Modeler 22.2 It's now available! #oracle #sqldev

6

31

97

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

6 years

Announcing Oracle SQL Developer Web - slides, video demo, and details here. #Oracle #Cloud #SQLDev #Web

6

54

93

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

5 years

We celebrated in March, but today marks the official year 20 mark, 20 years married to this lovely lady! yes, she hung out with me in the 90's, even with that haircut

13

1

95

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

2 years

The Rise of SQL... surprise!

The Rise of SQL

SQL dominated the jobs ranking in this year's IEEE Spectrum interactive rankings of the top programming languages. Normally, the top position is occupied by Python or other mainstays, such as C, C++,...

spectrum.ieee.org

7

23

90

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

4 years

Quick post for @OracleSQLDev , version 20.4 is now available! #oracle #sqldev

8

23

87

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

1 year

Latest @OracleAPEX is also on the 23c Free Developer Release VirtualBox VM VirtualBox download:

1

25

84

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

4 years

Slides & Video for @OracleREST 101 training I did for an internal group last week. Y'alls asked that I share it, so here you go! #Oracle #database #rest

1

33

84

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

4 years

Hopefully not the first to say this... DBAs...you've SEEN things. You've lived through trying to fix them. Imagine if you were a trusted partner on development projects. Imagine the problems we could avoid.

8

21

83

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

3 years

We're all gutted, obviously. Joel was THE example of what a customer driven mindset looked like. And the stories... so many. And I will read every single one. RIP, Joel..and Columbus lost it's #1 advocate.

Oracle APEX

@OracleAPEX

3 years

We're heartbroken to share that Joel Kallman has passed away from Covid-19 on May 25th. He was 54. Joel's warmth and enthusiasm touched countless across the globe. We miss him dearly. We invite you to share your memories: #orclapex @joelkallman

395

309

629

5

3

82

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

2 years

@tressiemcphd Great q&a though! You won me at

0

5

78

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

6 years

Hot Tip: Try reading your error messages and then if necessary, Googling them.

7

20

80

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

1 year

'Relational databases are great, but they can't scale' Uh-huh. Read what you can actually achieve when the requirements demand ACID, performance, security, and more -

11

13

78

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

3 months

📢 Release News - Oracle SQLDev Extension for VS Code, version 24.1 is now available!

SQL Developer Extension for VS Code v24.1 is now available

Oracle SQL Developer Extension for VS Code version 24.1 is now available on the VS Code Marketplace! Lots of bug fixes and several big new features.

www.thatjeffsmith.com

3

23

78

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

2 years

Student learning #SQL ? Some #Oracle must follows: @OracleDatabase @OracleSQLDev @sqldaily @pilatesdev @Loic__Lefevre @oraclebase @connor_mc_d

1

15

76

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

3 years

The Definitive Guide for building a REST API to insert a row to an @OracleDatabase table...with @OracleREST Table with an identity column AND lob (json), plus handlers for getting the record(s) back, complete with exception handling.

4

21

77

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

1 year

As a data modeling nerd, I hope, I pray that our new SQL Domains feature will really, really encourage folks to properly design their schemas before writing any code. Docs:

9

12

76

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

5 years

If you're planning a Oracle Database upgrade to 12c, STOP. You want to go to 19c. 19c is the terminal release in the 12c family and gets you the LONGEST support window. "Plus a potential extension of 3 years of Extended Support until March 2026"

Premier Support Extension for Oracle 19c – and more

Premier Support Extension for Oracle 19c - and more. The single source of truth MOS Note: 742060.1 has been significantly updated - read more

mikedietrichde.com

3

29

76

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

4 years

im putting together some REST, HTTP, JSON, ORDS basics slides for support training...would that be of interest to y'all as well? it'd be from a database professional's perspective, not a seasoned web developer (as that's who I am)

17

1

76

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

1 year

It's release day! @OracleSQLDev version 23.1 is now available for download. Everything you need to know... #oracle #database #sqldev

Oracle SQL Developer 23.1 is now available

Oracle SQL Developer and SQL Developer Data Modeler versions 23.1 are now available for download. These releases primarily contain bug fixes.

www.thatjeffsmith.com

10

30

76

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

1 year

Did you know? @OracleSQLDev can help you read Trace (TRC) Files @oraclebase knows :)

4

19

76

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

3 years

A favor: when attending online presentations, don't be shy on LIVE feedback and questions. As a presenter, doing an entire hour talk to a screen with nothing in return is a major bummer. Every little bit helps!

5

13

74

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

6 months

10k and growing! Thanks everyone for the support! We're readying our first update now, many many big fixes on tap! #oracle #sqldev

3

6

75

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

2 years

Mom started teaching in '74, "retired" in 2015...has been working full-time with at risk kids ever since. Oh and whilst being treated for cancer. My hero also introduced me to Lord of the Rings :)

3

0

70

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

5 years

My maternal grandmother passed earlier this morning. She was the epitome of a stubborn, proud, and hard working hillbilly. I'm going to miss her, her laugh, and her amazing cooking. #WV #family

59

0

71

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

3 years

Video recording, slides, and the code from yesterday's awesome CI/CD & Devops session for @OracleDatabase & @OracleAPEX with @btspendo #DevOps #100daysofcode #CICD #databases

3

33

69

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

3 years

Versions 21.3 of @oraclesqlcl @OracleREST @OracleSQLDev Web now available! With a quick shout-out to @oraclebase - thank him if you like the new Autotrace feature. #oracle #database #tools

4

30

71

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

1 year

Another @OracleSQLDev Next tease A mix of text/GUI..the features you come to expect, in a familiar presentation. With the flexibility and modern look and feel you've been asking for. More js than Java on the front end, but we're still leveraging 20 years of tech! #oracle #sql

11

17

71

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

1 year

I have to admit, 'DROP TABLE IF EXISTS' will be nice

7

3

70

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

5 years

New Post: SQL Developer Web is now available, for everyone! #oracle #database #tools #sqldev

2

23

70

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

2 years

I was worried Layla would be nervous, but her enthusiasm and wonder infected the rest of the team :)

layla

@pilatesdev

2 years

1st software demo ever in the books ✅ Today I demo’d the Self-Service tool I’m working on during my internship at @Oracle and I got such awesome feedback!! 🥳

33

22

1K

6

4

68

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

6 years

I am thinking about puttig together some resources for helping bloggers in the Oracle space - 1)get started 2)get readers 3)get to the next level...LIKE if you would find this useful.

1

5

66

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

3 years

This news is huge. Bigger than huge actually. Literally millions of #developers use #mysql and we're about to make web and app development that much easier for them, again, for free.

krisrice 🏒🍺📷

@krisrice

3 years

@OracleREST + @MySQL 🦾

2

8

28

1

13

71

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

2 years

Need an @OracleDatabase expert? All things DB @SQLMaria @GeraldVenzl HA @ashishray @KnownAsMarkus @RACMasterPM @ludodba Autonomous Data Tools @OraclePDB Microservices @paulparkinson Security @RussLowenthal ML @MarkHornick APEX @JaysonHanes Graph @AnnamalaiMelli 1/2

3

23

67

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

9 months

Closer closer, getting closer. Some internal demo next week prep...

6

5

70

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

4 years

Slides from my DBA Masterclass session on Data Modeling are now available...."optimized" for online viewing :) #oracle #datamodeling #database #dba #design #slides

4

13

69

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

2 years

If you want 'pretty' SQL and PL/SQL, these suggestions from @Trivadis @phsalvisberg seem to be well accepted in the @OracleDatabase developer community

3

26

68

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

8 years

alpha testing sqldev Web - you're gonna like this

10

26

67

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

4 years

The post you've been waiting for, versions 20.2 of @OracleSQLDev @oraclesqlcl & Data Modeler are now available! #oracle #SQLDev #ReleaseDay

4

36

65

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

7 months

To our @OracleDatabase tools users, enthusiasts, & reluctant passengers., thanks for an amazing 2023! 2024 is gonna be 🔥 SQLcl 23.4 & SQLDev for VS Code Extension will be first two goodies to drop in 2024. LiveSQL refresh is coming soon, great progress. Cheers & much love!

3

10

67

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

5 years

Coming very soon, ANSI <=> Oracle JOIN refactoring for your queries

6

15

66

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

3 years

Folks, we're literally JUST getting started with @OracleSQLDev Web. Coming soon, screens for DBMS_SCHEDULER, administering APEX Workspaces, and everything else you want/need.

5

16

66

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

20 days

This means instant downloads are now available, no more sign on, account creation, or license click-thru's required :)

Oracle Database

@OracleDatabase

20 days

Oracle SQL Developer is now available for download and usage via our Oracle Free Use License, resulting in easier access to our #1 database tool! You can also find our VS Code extension conveniently located here as well.

1

46

125

3

9

67

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

4 years

"customer is on 8i and wants to upgrade...to 10g"

16

2

66

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

4 years

Another note from someone wondering how to figure out who updated their stored procedure. Please please please please please please please please please please please start using source control and implement change request workflows for your databases. And stay out of PROD.

10

8

65

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

1 year

Getting closer :) LSP/Parser and PL/SQL editing/compiler coming around. Virtual File System/Breadcrumb navigation to supplement the connection tree for drilling around your dictionary will be a game-changer!

6

11

65

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

6 years

asked and answered: can @OracleSQLDev format my code so that keywords are right-aligned? Yes, in 18.1'ish.

8

16

62

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

3 years

Not missing work

5

0

62

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

4 years

That'll do. Now I just need a bada$$ poster for my wall.

17

0

63

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

3 months

You can now create your Always Free Autonomous Database 23ai instance in the Oracle Cloud

6

17

63

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

9 months

You'll soon have 3 ways to run your SQL (queries or scripts) for Oracle Interactive, one query, one grid Execute as a script, output below Fire up SQLcl CLI, connect, and run - terminal remains for further work

4

13

59

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

1 year

Two things folks don't realize about our tools, in this case @oraclesqlcl 1. You can use a TNS file, no client required, see what TNS file we're using with first few service entries. 2. TNSPing is built-in as a command. #oracle #database #tools #sql Favorite for reach!📢

5

13

60

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

6 months

Now trending... @OracleSQLDev for VS Code :) HT @martindsouza

6

7

62

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

10 months

Old boss, meet the new boss I may as well share some sneak peeks while I do some QA work this afternoon

5

9

60

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

4 years

A DDL script is NOT a data model.

13

4

61

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

1 year

My boss' boss apparently really like this feature. Getting help with ANSI Joins - using them, or getting rid of them :) Here's 9 more 'Mind-blowing GIFs' showing off features in your favorite Oracle Database IDE and query tool -

4

12

61

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

9 months

Met this guy over the weekend

6

1

60

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

2 years

I'm looking for someone to join our team and help with database migration technology #prodmgmt #oracle #Jobs

7

21

60

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

3 years

18 yr scotch at 42nd St celebrating 22 years with the missus, cheers!

12

0

59

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

2 years

How long do you struggle with something before asking for help? I tell people if they bang their heads for 30mins, they should probably go ahead and reach out. The beauty of asking for help - is often a trigger to enlightenment. The act of asking, often gives the answer.

17

8

58

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

7 years

Oracle SQL Developer version 4.2 is now available. Data Modeler too! #oracle #sqldev

2

57

59

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

3 years

Stolen from Instagram

4

7

60

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

6 years

New Post: @OracleSQLDev version 18.3 is now available.

5

33

56

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

4 years

I bet you've not see this before, but I also bet you could totally use it today to fix some serious performance problems in your production apps. Change out your bad SQL, on the fly. #oracle #sql #fast HT @GeraldVenzl @SQLMaria

3

16

57

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

4 years

2 beers in at the pool thoughts...what would anyone ever want to do with 13m rows in a query result? And don't you dare say export it to Excel; I will find you.

30

3

59

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

3 years

DATA MODELING AND PROPER DESIGN BEFORE YOU CREATE A SINGLE TABLE.

Javarevisited

@javarevisited

3 years

10 SQL Concepts every developer should learn 1. JOIN 2. GROUP BY 3. Window Function 4. Correlated subquery 5. Indexing 6. WHERE vs HAVING 7. UNION 8. Table Alias 9. Temp table 10. Functions what would you add more into this list? #SQL #Programming

16

49

174

6

11

58

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

2 years

I need your help - I'm looking for you to spend 5-10 minutes on this survey Help us make @OracleSQLDev Web, easier to use, better suited to your needs, and a joy to interact with! #oracle #cloud #sql #database #sqldeveloper

4

54

57

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

4 years

"Google the Error Messages" Master this, and you're ready for a career in IT.

4

59

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

6 years

Oracle XE 18c is coming, and it's going to blow you away.

5

21

58

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

4 months

This tip sounds silly, but seriously... Don't run queries with hundreds of columns. You're wasting server time, network bandwidth, and then you're taking your client UI and YOUR eyes to deal with that information. Query just the 5 or 6 columns you need.

7

13

59

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

3 years

nothing to see here

6

5

56

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

4 years

If you're looking for slides... ...you can find the newest ones here #oracle #dbtools

2

16

57

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

11 months

School's back in session! What if I told you, it's easy to setup Oracle to learn SQL?

The Easiest Ways to Get Started with Oracle Database!

Taking an Oracle Database class and need a system to practice your SQL or do your homework? Here are the easiest ways to get going in just a few minutes!

www.thatjeffsmith.com

1

20

55

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

3 years

@JenMsft I'm usually called in just to observe, then things start workimg. Then they get mad at ME.

8

0

57

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

2 years

Hey @OracleDatabase and @Apple fans - we have @OracleSQLDev that includes Java, for both Intel and ARM CPUs Version 22.2.1 now available!

3

14

57

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

9 years

An idea of what our PL/SQL debugger can do from Oracle SQL Developer http://t.co/ylQUjTtbWR

1

35

55

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

7 years

Please follow @ChrisAntognini @FranckPachot @ilmarkerm @kibeha @MDWidlake @dbaOnTap @oraculix @RebellionRider @oraesque @pfierens @swesley_perth @ddelmoli @alexzaballa @johnnyq72 @richardfoote @sspendol @Mautro @jpiwowar @nlitchfield @dgielis @RoelH -> non ORCL emps - great folks

14

16

57

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

2 years

New post! Let's see how to take your @Spotify listening history and use it to teach yourself #sql with @OracleDatabase ... for free! And NOTHING to install.

Learning SQL with your own Spotify Streaming History data

Importing your personal data from Spotify to a database for learning SQL can be done in just a few clicks with Oracle's Always Free Autonomous Database!

www.thatjeffsmith.com

4

8

56

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

4 years

Announcing our DBA Masterclass Series - @RussLowenthal @ChrisRSaxon and I covering the merits of good design, security, and application performance for your @OracleDatabase Free Registration Details - #oracle #sql #datamodeling #security

1

23

56

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

1 year

Release News! @OracleREST version 23.1 is now available for download! #orclapex administrators we have some new REST APIs for you! HT @cczarski

Oracle REST Data Services (ORDS) 23.1 is now Available

Oracle REST Data Services version 23.1 is now available for download! Simpler sign-ins, exporting your REST APIs, and new APEX mgt REST APIS!

www.thatjeffsmith.com

1

27

56

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

4 years

Maybe the best thing we've ever done here

6

10

56

SQL.ProductManager.Oracle.Databases

@thatjeffsmith

4 years

The @OracleDatabase #dbtools team wishes everyone a happy end to 2020 and hopefully a much improved 2021! Also, thanks to everyone for the supports, likes, favorites, RTs, and feedback!