It’s been a while since I posted anything work related but here’s one I discovered today. Have you ever needed to find out when a particular row was changed? From Oracle 10g there’s a feature which records the SCN number of a row change within the table in a pseudo-column called ora_rowscn. So for example: [...]
Posts Tagged ‘Oracle’
Tracking row changes in Oracle tables
Posted: July 5, 2011 in Geek Stuff, Oracle StuffTags: database, Oracle
0
SQLPlus Command Line History
Posted: November 17, 2010 in Geek Stuff, Oracle StuffTags: linux, Oracle, sqlplus
Wow, I can’t believe I’ve not considered this before! SQLPlus is a great tool, I use it all the time as it’s great for doing little bits and pieces where you don’t need the tools in SQL Developer (which is my preferred client for most big stuff) or you don’t want to go to the [...]
Oracle SQL Developer 3.0 on Ubuntu
Posted: November 16, 2010 in Geek Stuff, Oracle StuffTags: Oracle, sqldeveloper, ubuntu
This was one of my early posts and it seems the instructions work the same for the new October 2010 early release version of SQL Developer. (it was pretty straight forward anyway). Grab the SQL Developer 3.0 RPM from Oracle (registration required): You’ll need the Alien package to convert the SQL Developer .rpm to a [...]
