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.

7h
comment Selecting Maximum number of concurrent records based on timeStart and timeEnd values
@RobertoLinares - you used the same ID twice; this only works if they are unique. This still gets 3. The prior thing is a trick to stop the connect-by looping.
7h
answered Selecting Maximum number of concurrent records based on timeStart and timeEnd values
8h
comment Selecting Maximum number of concurrent records based on timeStart and timeEnd values
Not sure lag works here as they are independent but overlapping records? (And it's tagged for Oracle)
8h
revised ORA-20001: An error was encountered - -917 -ERROR- ORA-00917: missing comma
Additional thoughts
8h
revised ORA-20001: An error was encountered - -917 -ERROR- ORA-00917: missing comma
added 225 characters in body
8h
answered ORA-20001: An error was encountered - -917 -ERROR- ORA-00917: missing comma
11h
comment Why does ora_rowscn change without updating a table
Is your staging table (which I assume is where you see this) an external table? Or populated by SQL*Loader, or some other process?
12h
revised Why does ora_rowscn change without updating a table
added 2 characters in body; edited tags; edited title
12h
comment Why does ora_rowscn change without updating a table
I don't see that; max(b.current_scn) is increasing of course, but max(ora_rowscn) stays stable. But then you said it wasn't every table, which is also interesting. Which patch level are you running? Do you actually see this behaviour with your test table?
12h
comment Oracle extractvalue with dynamic namespace
You can replace extractValue with XMLQuery; and existsNode with XMLExists. Not direct replacements, you'll need to figure out the XQuery versions of your conditions.
12h
revised Oracle extractvalue with dynamic namespace
added 243 characters in body
13h
answered Oracle extractvalue with dynamic namespace
13h
comment Oracle extractvalue with dynamic namespace
Then that is surprising; except that extractValue is deprecated of course. XMLQuery and XMLTable versions worked for me in 11gR2, so perhaps they will for you in 12c? I don't have a 12c instance to test them on.
16h
comment Oracle extractvalue with dynamic namespace
I get TEST1 and TEST2 from your final query. In 11gR2 (11.2.0.3); but TEST1 and null in 10gR2 (10.2.0.5). What version are you getting null in?
16h
revised Migration script with dbms_lob.substr gets "character string buffer too small"
Added basic bulk insert option
16h
revised Migration script with dbms_lob.substr gets "character string buffer too small"
Formatting and minor tidy up
16h
revised Migration script with dbms_lob.substr gets "character string buffer too small"
added 966 characters in body
17h
answered Migration script with dbms_lob.substr gets "character string buffer too small"
17h
comment Migration script with dbms_lob.substr gets "character string buffer too small"
Is your source column really a CLOB, or an NCLOB? What are your character sets?
18h
revised What are the minimal steps needed to configure a SAML 2.0 Identity Provider in Weblogic
edited tags
1 2 3 4 5