Alex Poole

United Kingdom

stackexchange.com/users/98359

Age: 43

I've been picking up hints, tips and information from a variety of sources over the years, but somehow have always been a taker and not a giver. I'm finally getting involved and trying to give something back to the community. Still learning far more than contributing though.

I'm a bit of a jack-of-all-trades in a small UK-based team within a US subsidiary of a Japanese company, doing work for a large UK telecoms provider. Production support, developer, part-time (a.k.a accidental) DBA in dev/test, analyst, consultant... whatever needs doing right now, generally. Mostly Oracle (since about 1995, versions 6 to 11g), Java, WebLogic, shell scripting, HTML, CSS, a bit of C when pushed, but whatever's needed today. Work is mostly on Oracle Linux, but dragged into Windows and networking issues fairly often, and a Mac user at home.

14m
revised Updating rows based on another table
Added example based on AD_VP question edit and comment
25m
answered Updating rows based on another table
34m
comment Updating rows based on another table
Where is ad_vp coming from? Are you expecting only one person to have each job_id, or the salary to be the same for all employees with that? Maybe you can add some sample data and expected final result.
37m
revised Updating rows based on another table
Spelling, minor formatting and clarification, tags
51m
comment SQLDeveloper 1.5 and 3+/4+ version different primary key
Where exactly are you seeing the information you've described? Where do you only see four columns? Do you have DDL to create the table/PK/index that shows this behaviour, and step-by-step instructions to see what you are seeing?
1h
comment SQLDeveloper 1.5 and 3+/4+ version different primary key
What is your question? Why your developer made a mistake? I don't think it's clear what the issue is, if there is one.
3h
comment Oracle Import option
Is your column defined as 250 bytes or 250 characters? If the latter - and it sounds like it should be - then you shouldn't need to change the size. I don't think you'll see 'growth' going from existing Western data to UTF anyway. And if you did resize in bytes, it would need to be wide enough for any future data, not just what you have now. Are you building the table before importing the data, or is the import creating it?
3h
awarded Critic
4h
comment Creating a sequence with max value of an existing table
possible duplicate of How to create an Oracle sequence starting with max value from a table?
4h
comment how to concatenate more than two columns in plsql developer?
Oracle uses || as the string concatenation operator, not +; and doesn't enclose column names in square brackets. The OP also hasn't asked for commas between the values.
5h
comment Oracle database server on 64bit Windows 8.1
The simple answer is yes, but you already know that. If you have specific issues with the installation then you could ask about those, giving details of what you downloaded, what you ran, parameters supplied etc., and what happened. But it's off-topic for this site.
5h
revised Oracle: Select Min with Where Clause
Fixed end date in analytic query; added correlated version; added SQL Fiddle demos
5h
revised Oracle: Select Min with Where Clause
Fixed end date in final query; added SQL Fiddle demo
5h
comment Oracle: Select Min with Where Clause
You have the right number, but in the wrong place; SELECT(MIN... should be (SELECT MIN.... So you need to move that opening parenthesis for both subqueries, rather than adding another set.
5h
revised Oracle: Select Min with Where Clause
Corrected initial parentheses comment
5h
revised Oracle: Select Min with Where Clause
added 585 characters in body
6h
answered Oracle: Select Min with Where Clause
6h
revised NLS_SORT is not used in partial select
Added version note and SQL Fiddle links
6h
comment NLS_SORT is not used in partial select
If you're on 12.1.0.1, this might be bug 18353141 or 16934803, both of which look in the right area, and are mentioned in the 12.1.0.2 patch set release notes. You can check My Oracle Support for more details, and/or raise a service request to confirm the issue. If you're already on 12.1.0.2 then you might need to raise a service request anyway.
6h
comment NLS_SORT is not used in partial select
Mmm, interesting; sorry though I don't have access to 12c at the moment. Might be worth editing the question to say exactly which version/patch level you're seeing this behaviour in, in case it's a bug that's already been fixed.
1 2 3 4 5