13,594 reputation
12048
bio website google.com
location Manchester, United Kingdom
age 36
visits member for 2 years, 6 months
seen 2 days ago

Oracle DBA, Unix admin.

Available for employment! ;)


Mar
16
comment sqlfiddle: leading blanks are gone
Tweet @sqlfiddle and Jake will look at it. Not sure posting a site bug as a question on here is the best way of going about things.
Mar
15
comment In SQL*Plus, how do I run @https://here.is.url/script.sql behind a proxy?
Done, thanks René
Mar
15
answered In SQL*Plus, how do I run @https://here.is.url/script.sql behind a proxy?
Mar
14
answered Oracle 12c create user
Mar
13
comment Exception in SQL client but not in stored procedure
GMT daylight savings doesn't start for a few more weeks. It'll be your client-side CDT that has caused it, as Americaland changed last weekend
Mar
13
comment Exception in SQL client but not in stored procedure
Works fine on sqlfiddle. sqlfiddle.com/#!4/970e3/1 what're your NLS settings?
Mar
13
reviewed Approve suggested edit on Database tables to store all old relations between them (SQL)
Mar
13
comment Oracle Merge performance
Never, ever, read anything from that website. I won't say any more, as he's known to sue
Mar
13
comment In SQL*Plus, how do I run @https://here.is.url/script.sql behind a proxy?
Stupid comment system... You need http:// after the equals sign
Mar
13
comment In SQL*Plus, how do I run @https://here.is.url/script.sql behind a proxy?
The usual way (at least for Unix) to set a proxy is to set the environment variable HTTP_PROXY. So try setting HTTP_PROXY=username:password@proxyhost - I imagine it'll work the same for windows
Mar
13
reviewed Approve suggested edit on Permission denied in Postgres
Mar
12
comment Dynamically change schema to accommodate custom fields!
Dynamically adding columns is very silly. en.wikipedia.org/wiki/Entity–attribute–value_model is your best bet
Mar
12
comment How does the transactions interact if you set a different isolation level per connection?
You are aware that you're using mysql and not a RDBMS that cares?
Mar
12
revised SQLPlus Padding in Query Results
edited tags
Mar
12
comment SQLPlus Padding in Query Results
Yeah, the latter will be multibyte hence the padding (increased column length).
Mar
12
revised How to export oracle 11g database partially
edited tags
Mar
12
comment How to export oracle 11g database partially
As Justin says, I imagine you need referential integ. Do you know the data?
Mar
11
reviewed Approve suggested edit on Trying to create a sequence in Oracle that starts with the max value of primary key of a specific table. Why does this not work?
Mar
10
comment Database software advice
You need to give us some kind of clue... What selectivity do the rows have? What kind of data is it?
Mar
10
reviewed Approve suggested edit on Review a database schema for a design approval system