ThatJeffSmith

Oracle SQL Developer: Code on Demand

I’ve recently spent a few hours debugging some user defined reports. A post on how to add trace/disconnect context menus to a session report required that I figure out what session my worksheet was running under. The code was easy… SELECT SYS_CONTEXT (’USERENV’, ‘SID’) FROM DUAL; …but I’m lazy. So this: The Setup Open your […]

Similar Posts by Subject Areas: , , , ,

Non-English Character Display in Oracle SQL Developer

I get a variation on this question at least once a week, if not more frequently. I’m from Israel, and the language on the databases is Hebrew. When I use the old and deprecated SQL*Plus (windows rich client) I can see the hebrew clearly, when I use the latest SQL Developer, I get gibberish. This […]

Similar Posts by Subject Areas: , ,

I Know What I Did This Summer: Put Down Trex Decking

If you’re wondering why I would bore everyone with my pictures and frequent status updates/tweets from the past week – it’s so I could document the process of refurbishing my deck, or what some would call a porch. When my wife and I go to take a vacation, buy a car, do anything – we […]

SQL Developer Quick Tip: Running Scripts off the Web

Did you know you can run SQL*Plus type scripts directly from the web? Now, I’m going to assume the following: You know, trust, and have tested these scripts You don’t assume that everything on the Internet is true That Tim doesn’t think I’m trying to suck up to him, much So, in a SQL Worksheet, […]

Similar Posts by Subject Areas: ,

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 […]

Similar Posts by Subject Areas: ,

SQL Developer at Oracle Open World 2014

Oracle Open World is just around the corner. Every year, tens of thousands of Oracle geeks gather in San Francisco for a week for learning, networking, and more than a little bit of fun and socializing. If you’re going to be there, here’s what you need to know about your favorite development tools team Fun […]

Similar Posts by Subject Areas: , , ,

Oracle SQL Developer Around the World

Oracle SQL Developer is being used around the world. I see evidence of this in Indonesian tweets, OTN forum questions written in Spanish, talking to people at the larger tech conferences, and looking at our website Google Analytics. For just this site, here’s where people have visited from in 2014: If I look at the […]

3 More Oracle SQL Developer Bloggers

I’m on vacation this week – so in order to keep you folks entertained, I thought I would spotlight a few of our developers who also blog. Kris Rice Kris is one of the two original developers of SQL Developer. He’s also my boss, but don’t blame him for me. Lately, he’s been into all […]

Similar Posts by Subject Areas: ,

How to Generate Schema DDL Scripts with One File Per Table using SQL Developer

A VERY specific request this morning: I want to generate scripts for all the tables available in schema. I want to generate separate scripts for each table available in schema and each script must contains it’s dependent objects like indexes for that table or if triggers are available the this must include in the script. […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: ,