You want to drop, purge 10 tables, and you don’t want to select, click, click, click 10x. What’s a SQL Developer user to do? Well, if you want to live dangerously, you could build a custom extension for SQL Developer to do that for you. We tweaked the IDE to allow this in version 4.1.2 – if you’re on any version PRIOR to version 4.1.2, this won’t work. BASICALLY… You can have an item type…
This has been around for a loooooong time. But after a short chat with @oraclebase AKA Tim Hall yesterday, I thought I’d make sure we’re doing things right in the SQLDev tooling. Tim uses it to make very nice, short, and sweet video demonstrations on his YouTube Channel. I highly recommend it. Anyways, back to PAUSE. SET PAUSE ON [DOCS] in sql*plus allows a script to ‘pause’ until you hit ‘ENTER’ for it to continue.…
Start a debug session…step over some code…look at a variable…run to a breakpoint…investigate the data in a PL/SQL table…step into another program…check out the callstack. Just another day in animated GIFs and showing you what SQL Developer is capable of. If you’re curious or want more info, hit the ‘debug’ link at the end of this for all of my debugger posts. Hint, scroll down to just right above where the comments start. Click on…
For those Windows users out there who want both a BASH shell AND a really cool command line interface to Oracle Database – I have good news! We updated SQLcl yesterday to include support for CYGWIN. I have Cygwin64 and Windows 7. We also added a new command, SHOW TNS. This will help you figure out how and where we’re finding your TNSNAMES* files. 1436322372662a8e5704a1c_000002 So we’ll look in your home directory, your TNS_ADMIN space,…
When demonstrating SQLcl, I get the feeling that half of the audience is filled with dread. Yes, they love everything that I’m showing them. But deep, deep down they are scared that the things they personally liked in SQL*Plus are going away. I’m here today to alleviate those concerns. Instead of asking you to just take my word for it, I’ll show you. Now of course you COULD just download it yourself and have a…
I’m a fan of both. When describing an Entity, I like to keep it ‘real.’ My beer or brewery doesn’t have an ‘ID.’ But when I go to manage this data in the real world, I don’t want 3 or 4 columns used to uniquely identify a record in my table. Or tuple if you want to be all fancy. So can I have it both ways? Yes. In your logical design, define your entities…
One of the most viewed threads over the last 30 days in our OTN Community for SQL Developer is a post from 2010. 2010. Wow, I says to myself – that’s gotta be interesting to a lot of folks, what is it? It’s a question on how to find table or view columns. And the ‘correct’ answer is to use SQL. Which is of course the right answer, and was the right answer in 2010…
It’s that time of year again: planning for our biggest customer and user event, Oracle Open World. I recently shared some advice for getting the most out of your conference experience, here’s a 2 minute video: One of the bits there I suggested was to mark one or two sessions a day that you might want to attend. Well, since you’re here, I’m assuming you might find the stuff our team is doing appealing. Note…
Haven’t had much time to blog this week, so what’s a blogging addict to do? Ask your readers for help! @thatjeffsmith kind of like db instance but more focused. I picked 3 just to give an idea. Refresh would be on all. pic.twitter.com/WUlWyUbeT3— Nando Somoza (@slaytanic70) September 10, 2015 So I put together this view for Nando…3 reports running all at once, and all displayed at once. Blocking Locks by User (top left) ASH Rows…
You’ve just installed a new copy of SQL Developer. Here are some things you might want to change in the preferences. Notes: I said ‘fixed field’ – I meant FIXED WIDTH fonts, duh If you think you’re hearing Foreigner’s Feels Like The First Time, you’re wrong Some of the tips in blog format: fonts zebra line numbers open on SINGLE CLICK! connection folders query results new grids