Alex Poole

Derbyshire, United Kingdom

stackexchange.com/users/98359

Age: 43

I'm a bit of a jack-of-all-trades in a small UK-based team within a US subsidiary of a Japanese company, working on switch activation software for a large UK telecoms provider.

Among other things I'm a support analyst, developer, part-time (a.k.a accidental) DBA in dev/test, requirements analyst, technical 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 and Pro*C when pushed, but whatever's needed today. Work is mostly on Oracle Linux now, but dragged into Windows and networking issues fairly often, and a Mac user at home (since about 1986).

I am, of course, #SOreadytohelp

3h
comment Convert TimeStamp in TZ string format to TimeStamp in Oracle
@WernfriedDomscheit - yes, hence the third option to force that, which is probably most correct. Maybe I should have been clearer that it should be used though. What I haven't covered is converting that UTC value back to the OP's (session or database) timezone, which I guess should be done if it willl be stored as a timezone without timestamp.
5h
revised Convert TimeStamp in TZ string format to TimeStamp in Oracle
added 306 characters in body
10h
answered Convert TimeStamp in TZ string format to TimeStamp in Oracle
13h
revised Update Value Based On Value In Another Table
Added joins to intermediate table
14h
revised Update Value Based On Value In Another Table
added 1 character in body
14h
answered Update Value Based On Value In Another Table
14h
comment Update Value Based On Value In Another Table
Possible duplicate of Update statement with inner join on Oracle
14h
comment Update Value Based On Value In Another Table
This approach is not valid in Oracle, which does not let you have a join in the update statement.
14h
comment cx oracle ImportError
@Eric - as with Julia, this haas solved the original issue and it looks like a project or environment set-up problem, maybe. If you can't figure it out you should ask a new question specifically about that.
1d
revised Merging multiple rows and column data into single concatenated row
edited tags
1d
revised Merging multiple rows and column data into single concatenated row
added 714 characters in body
1d
answered Merging multiple rows and column data into single concatenated row
1d
comment why is oracle ignoring scale in number datatype
Which client are you running that in? Looks like whatever it is is set to only show two decimal places - it's a client issue though, not an Oracle one, and doesn't affect how the value would be stored. You can see that with select to_char(cast(2457431.6443981482 as number(25,13)), '9999999.9999999') which will bypass the client number formatting.
1d
comment Converting crystal report code to Oracle SQL query for date range
@aquariumjunky - I've added some explanation of what the short version of the calculation is doing; hope that helps.
1d
revised Converting crystal report code to Oracle SQL query for date range
Added a breakdown of what the short version is doing
1d
revised Converting crystal report code to Oracle SQL query for date range
Fixed period-end calculation
1d
revised Converting crystal report code to Oracle SQL query for date range
Added demo
1d
answered Converting crystal report code to Oracle SQL query for date range
1d
comment Converting crystal report code to Oracle SQL query for date range
What are you expecting that to evaluate as? Just plugging in the obvious Oracle equivalents gives 2016-02-07, going back five days, but I'm not sure the 14s mean the same thing. Even if it the right thing, what should the time component be - midnight on whatever day that is, or the current time on that date?
1d
comment How to display records from a table,order as in the where clause?
@jarlh - The q denotes the alternative quoting mechanism, which saves having to escape the single quotes. (Might have been useful here *8-)
1 2 3 4 5