12,910 reputation
11741
bio website google.com
location Manchester, United Kingdom
age 36
visits member for 2 years, 3 months
seen 1 hour ago

Oracle DBA, Unix admin.

Available for employment! ;)


Mar
18
answered Oracle How to find Debug Compiled Stored Procedures/Functions
Mar
17
answered What is the instance name of the box I'm logged into?
Mar
17
comment Where .dmp file is restored after import in oracle?
You're missing the obvious thing that an Oracle user is a schema, which (until 12c) equates to a MySQL "database". That is almost certainly why the OP is confused.
Mar
17
reviewed Approve suggested edit on How to find the same salaries and department names?
Mar
17
revised Oracle 12c create user
deleted 7 characters in body
Mar
17
comment Oracle 12c create user
@steve so pedantic. That requires the "GLOBAL" clause and isn't anything to do with this question
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