Top 60 Oracle Blogs

Recent comments

Jonathan Lewis's tweets

@OracleSK I mean the thing behaves in exactly the same way was your other examples. cast('X' as varchar2(20) makes no difference. — 1 week 1 day ago
@OracleSK Just tried it, it doesn't work in 19.3. — 1 week 1 day ago
@OracleSK There is a difference, though, in that the data type of your 'X' is not in the data dictionary but the da… week 1 day ago
@OracleSK So the behaviour does have a similar feel to your example - did you try cast('X' as varchar2(1)) to see if that had any effect ? — 1 week 1 day ago
@OracleSK Nothing interesting. The table_type attributes project as VALUE(A0)[22], VALUE(A0)[6], VALUE(A0)[10], VA… week 1 day ago
Went to see "The ocean at the end of the lane" at the NT (Dorfman ) Thursday. Lovely story… week 1 day ago
RT @FunkyAppleTree: Tonight's #PenumbralLunarEclipse was as subtle as hell, and it's only when you look at the collective moons you can spo… — 1 week 2 days ago
@AndrewSayer_ Very clever - getting an exact structure (table and indexing) match gives you a "partition view" rath… week 2 days ago
@MDWidlake For a moment I thought you meant that was a sample you'd prepared for your GP to test. — 1 week 2 days ago
@MDWidlake Don't forget to have a passport that will be less than 10 years old with at least 6 months to run from t… week 2 days ago