For some reason Oracle have no Boolean Since there is no BOOLEAN datatype in Oracle, as far as tables are concerned. CREATE TABLE BooleanTable (MyBool BOOLEAN); return : ORA-00902: invalid datatype But there is a BOOLEAN datatype in PL/SQL. What should we do instead? According to Tom at ThinkOracle you could create the table using […]
How to fix: ERROR – jmeter.save.SaveService: Conversion error com.thoughtworks.xstream.converters.ConversionException
When you are handling string you sometime have single quote in your string. I was looking on how to handle that in Oracle and it’s not pretty but you can cover that case with the chr(39) function, 39 being the code for the single quote. So it you are looking the “it’s” you have to […]
I had in the past had to work with oracle and had to convert it to mysql. Unfortunately (or fortunately) that project was cancel but here are the bit of information I’ve found that I didn’t know about and made me lost a lot of time. Oracle vs mySQL datatype edition From mySQL […]
Recent Comments