Mark Sta Ana booyaa

Got this gem (paraphrased by me) from a fellow cow-orker whilst on a soft skills course:

A department of developers are analogous to a cricket team, as infrastructure/ops support are to a football team. We're a group of specialists, who move together as one, with a common goal of making the business successful. However at the end of the day the batsman still has to hit the ball all by his or herself. The rest of the team can't help them do this.

##Packaged stored procedures carp with the following error

failed with the following error: "ORA-01858: a non-numeric character was found where a numeric was expected

Add this to the end of your Oracle Connection Manager: UseSessionFormat=true

##Codepage warnings

Update this property in your Oracle ConnectionManager

###OpenByReplicaID

@Command([FileOpenDBRepID];@Prompt([OkCancelEdit]; "Enter Replica ID"; "I will open the db based on Replica"; "00000000:00000000"))

###ViewReplicaID

@Prompt([OkCancelEdit]; "Replica ID"; "Copy the code below"; @ReplicaID)

###View Db Props

####Oracle (requires r11.2 or better)

It's easier to break down the query into pieces. You have the following table:

songtitle               | artist
final countdown         | europe
hello                   | lionel richie
never gonna give you up | rich ashley

You'd like it to look like this

	<!-- RIBCL Sample Script for Integrated Lights-Out -->
	<!-- Copyright (c) 2003 Hewlett-Packard Development Company, L.P. -->

	<!-- Description: This is a sample XML script to modify an existing -->
	<!-- user's login id, display name, password and/or -->
	<!-- privileges in the database of local users on an -->
	<!-- iLO device. -->

	<!-- NOTE: You will need to replace the values inside the quote -->
	<!-- marks with values that are appropriate for your -->

	<!-- RIBCL Sample Script for Integrated Lights-Out -->
	<!-- Copyright (c) 2003 Hewlett-Packard Development Company, L.P. -->

	<!-- Description: This is a sample XML script to toggle the power -->
	<!-- on the host server in which the iLO is executing. -->

	<!-- NOTE: You will need to replace the USER_LOGIN and PASSWORD -->
	<!-- values with values that are appropriate for your -->
	<!-- environment. -->

	module.exports = {
	apiKey : 'YOUR OPEN EXCHANGE RATES API KEY'
	, sourceCcy : 'USD'
	, targetCcy : 'GBP'
	}

	#!/usr/bin/env node

	// kinda works
	// npm modules: pdfkit
	// pre-req is a calendar file: ncal -y > 2012.txt
	// usage ./readCal.js

	var fs = require('fs')
	, path = require('path')
	, PDFDocument = require('pdfkit')

	UPDATE f
	SET isAwesome = 1
	FROM foo f
	INNER JOIN bar b
	ON f.id = b.id

	clear
	SET HEAD ON
	SET VERIFY OFF
	col instance_name form a8 Heading "Instance"
	col name form a8 Heading "DB Name"
	col host_name form a12 Heading "Hostname"
	select version
	,name
	,log_mode
	,host_name