Tag: oracle

The PL/SQL Debugger Strikes Back: Episode V

I’ve already discussed how the Rebel scum go about figuring out what’s wrong with their code. Now I want to get into the nitty-gritty details of how to start a debug session in SQL Developer. There are some prerequisites, but I promise it won’t take but a few moments to setup. Ensure that you have […]

Similar Posts by Subject Areas: , , ,

Code Completion Insight with Oracle SQL Developer

Most third generation language (3GL) IDEs have trained hackers like me to expect the tool to write some of the code for them. Regular internet folks are already used to having search terms and URLs auto-completed in their browsers. I don’t want to get into a debate over whether this makes us lazier AND dumber, […]

Similar Posts by Subject Areas: , , , ,

Free Beer or How to Get Free Demo Data from iTunes

Are you sick and tired of playing with the same sample data? Do you shudder at even the mention of the name, ‘Scott?’ First of all, if you’re still using SCOTT, you should try out HR instead. And if you want some beefier tables and need to experiment with partitioning, then SH is the way […]

Similar Posts by Subject Areas: ,

Click AND Type your Queries with the Integrated Query Builder

I was perusing the SQL Developer Feature Requests Exchange and was not surprised to see this – a request to have the Query Builder disabled. My favorite (and most predictable) comment among the voters for this request is something along the lines of ‘feature totally useless for us professionals’ Let’s explore that for a second. […]

Similar Posts by Subject Areas: , ,

Day 1: Give me a keep-alive button!

In case you’re curious, I’m calling yesterday ‘Day 0′ as it was spent doing trivial things like getting email setup. Today I feel like was closer to a real day of work. I spent a few hours this afternoon going over some request from the users. One stuck out pretty prominently – ‘Keep-alive functionality’ The […]

Similar Posts by Subject Areas: ,

Day 0: In the beginning…

…there were email and VPN accounts. Had my first conference call, complete with desktop sharing. Direct deposit and tax forms are out of the way. Everyone (I think) is remote, so instant messaging is one of the preferred communication methods. Looks like we’ll have a chance to meet in person for a team meeting outside […]

Similar Posts by Subject Areas: , ,

My New Gig

The good folks at Oracle, namely @krisrice, approached me this past Summer with an offer I found myself unable to refuse. The short version would be something like, ‘Hey, come join our SQL Developer team.’ So next week, I will start the next chapter of my professional life as the Product Manager for Oracle’s primary […]

Similar Posts by Subject Areas: , ,

Oracle: Move Table to new Schema and Tablespace

A Toad user posed this question today: Is there a way to move a (marked) TABLE mytable123 from Tablespace AAA and Schema BBB to another Tablespace USERS and Schema MYSCH? Let’s tackle the 2nd and easiest part first! Moving a table or partition to a new tablespace is pretty straightforward: ALTER TABLE table_name MOVE TABLESPACE […]

Similar Posts by Subject Areas: ,

What’s Your Favorite IDE for PL/SQL Programming?

I stumbled upon an interesting discussion in the ODTUG group on LinkedIn this weekend. A vendor is doing some research I suppose and wanted to know who enjoyed using what IDE and why. Here’s the original question: In your opinion which is the best IDE for PL/SQL programming and why? e.g. PL/SQL Developer, Toad, Oracle […]

Similar Posts by Subject Areas: , ,

Hint Abuse: SQL Server vs Oracle

I’ve overheard the SQL Server folks talking about the challenges of support applications where the NOLOCK (or is it NO_LOCK?) hint has been deployed to make transactions and queries go faster. This probably causes more problems than it solves, and rather trying to rehash what I’ve heard second hand, I suggest you go listen to […]

Similar Posts by Subject Areas: ,

Oracle Discovery Tool?

My employer has a freeware utility you can run on your network to find and document instances of SQL Server. One of SQL Server’s primary advantages is also one of its primary disadvantages – you can spin one up in a manner of minutes. To grow deals at a company buying our SQL Server software, […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , ,