network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 9 months |
| seen | Dec 3 '12 at 14:13 | |
| stats | profile views | 5 |
|
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 |
