Java Thinking

When making support requests it is always helpful to include version information about the product in question. Rather than just stating 'version X' I like to get the software to display the version information and just copy and paste it - this way there can be no confusion, and there may even be extra useful information. So, how to display the oracle version information? I came across this useful post which suggests: select banner from v$version; which on the instance I'm looking at produces: BANNER---------------------------------------------------------------- Oracle10g Enterprise Edition Release 10.2.0.3.0 - Production PL/SQL Release 10.2.0.3.0 - Production CORE    10.2.0.3.0       Production TNS for Solaris: Version 10.2.0.3.0 - Production NLSRTL Version 10.2.0.3.0 - Production Being an SQL query is even more useful than a command line, since you can run this within your applications if you need to display such data.

Last November I upgraded my desktop PC. Recently I've repurposed it as a media center running MythTV (and also for print serving/file serving etc). The hardware is as follows: Sonata III 500 W case Gigabyte GA965P-S3 motherboard Core2 Duo E6550 CPU Gigabyte 8400GS Nvidia video card WinFast DTV1000 digital tuner card 320MB SATA disk Kingston 1Gig DDR2 800MHz memory Since then, I've added a 1Terabyte SATA disk - prices keep coming down every week. You can get a 1T disk for just over AUD200 now. I installed MythBuntu 8.04 and found it a very simple process. I had to configure it for TwinView (Clone) so I've got the same output on my TV as I have on the LCD monitor. Then I had to get sound via the SPDIF optical output. To do this you have to: Unmute the ICE958 channel via alsamixer Configure MythTV to use ALSA:SPDIF and AC3 + DTS to SPDIF passthrough I also had to change my video player command to 'mplayer -ao alsa:device=spdif -fs -zoom -quiet so -vo xv