13,859 reputation
12150
bio website google.com
location Manchester, United Kingdom
age 37
visits member for 2 years, 10 months
seen 9 hours ago

Oracle DBA, Unix admin.

Available for employment! ;)


Dec
12
answered Get records which doesn't have duplicate records
Dec
11
comment Get records which doesn't have duplicate records
Your question isn't clear. Do you want to avoid all of the policies highlighted in bold, or all of the ones with the same policy number as well as those highlighted in bold?
Dec
11
comment Oracle 11gR2 IMP Won't Import Table in Dump File From 10g
Oh, sorry. I assumed imp/exp died a death years ago and didn't read your question correctly :) My apologies.
Dec
11
comment Oracle 11gR2 IMP Won't Import Table in Dump File From 10g
Try adding a REMAP_SCHEMA parameter
Dec
10
comment Internal query on CDEF$ and CON$ very CPU bound
Under no circumstances create indexes on internal Oracle views/tables!
Dec
10
comment How do i replace DENSE_RANK() with a SEQUENCE object
What are you actually trying to achieve?
Dec
9
comment MySql One-to-zero to one-to-one
You do realise that multiple people live at the same address in many cases?
Dec
9
revised Error adding constraint foreign key to bridge table
formatted SQL
Dec
9
comment Hierarchy of Employee “names” with CTE: Cannot create a correct version
Up vote for you Kin :)
Dec
9
answered Hierarchy of Employee “names” with CTE: Cannot create a correct version
Dec
9
comment Hierarchy of Employee “names” with CTE: Cannot create a correct version
If you specify the root node in the CTE, it works ok. Fiddle: sqlfiddle.com/#!6/bf4c1/9
Dec
9
comment How to store logs correctly?
"make a new table only for storing long contents." -- I'd do that
Dec
9
comment Query Previous Records (Oracle)
Was just about to post mine using LEAD() and DESC :) haha.
Dec
9
answered How can the LEFT JOIN return more results than the unjoined query?
Dec
9
comment How can the LEFT JOIN return more results than the unjoined query?
Each row in the first table may match more than one row in the second table. You can check this with SELECT l.id,count(*) FROM list l LEFT JOIN cardinal c ON l.id=c.id WHERE c.resolution IN ('Left','Right','Up') AND l.source='blink' group by l.id having count(*)>1;
Dec
9
comment How can the LEFT JOIN return more results than the unjoined query?
Sorry, I'm not awake yet and the answer is obvious. It's a 1<>many relationship between the two tables
Dec
9
comment How can the LEFT JOIN return more results than the unjoined query?
en.wikipedia.org/wiki/Join_(SQL)#Left_outer_join
Dec
9
comment Oracle APEX Button creating ORA-00920
Could be a grants problem for the APEX user. Also, sounds like your table needed a database_name column
Dec
8
answered Why does the same query run faster the second time I run it?
Dec
7
comment Warning before issuing delete/update command in mysql/oracle , then executes
"I would argue that this fixes the wrong problem, which is that you have privileges granted to people that they are not qualified to hold." -- That alone should be the answer to the question. On the Oracle size of things - you're paying license fees in the tens of thousands at least, so why skimp on staff?