132 reputation
5
bio website
location
age
visits member for 2 years, 1 month
seen Feb 3 at 12:28

Mar
5
awarded  Popular Question
Jan
16
accepted ADD Column ON UPDATE TIMESTAMP
Jan
16
asked ADD Column ON UPDATE TIMESTAMP
Oct
23
awarded  Popular Question
Dec
3
comment Oracle TRANSLATE Not Returning Expected Result
So we got some odd behavior. We were running a CSSCAN to determine if we were going to have some truncation issues. The initial scan told us that we had 200+ rows. After we ran the truncate command, we ran the scan and it decreased to 60. We ran the translate command on those 60 rows and nothing. However, when I then created a PL/SQL script and looped through each of the 60 rows and executed the exact same translate command, it updated the rows properly. The SCCAN results then said everything was fine. I can't really explain why that occurred but there nothing wrong with the translate command.
Nov
30
awarded  Editor
Nov
30
revised Oracle TRANSLATE Not Returning Expected Result
deleted 11 characters in body
Nov
30
comment Oracle TRANSLATE Not Returning Expected Result
Sorry, I just included some random 'blahs' in my example. We are in fact replacing specific characters in our query.
Nov
30
comment Oracle TRANSLATE Not Returning Expected Result
Thanks Phil. The DBA has been inspecting it in the same session without committing.
Nov
30
asked Oracle TRANSLATE Not Returning Expected Result
Oct
5
asked Split CLOB into multiple VARCHAR2
Aug
16
comment Character Set Database Migration
Thanks Phil. I just wanted to confirm my understanding of your comment that the "hard limit for any CHAR/VARCHAR column in Oracle is 4000 bytes". So if I define VARCHAR2(4000 CHAR) and then attempt to insert 4000 multi-byte characters, would that result in an error?
Aug
16
accepted Character Set Database Migration
Aug
16
asked Character Set Database Migration
Aug
3
awarded  Scholar
Aug
3
accepted Oracle 10.2g Character Set Migration
Aug
3
awarded  Student
Aug
2
asked Oracle 10.2g Character Set Migration