By Chris on September 20, 2014
My god sometime I bang my head on the wall to do something simple on oracle. So oracle don’t support limit so to do something simple has : SELECT f_name, l_name, age from employee_data ORDER BY age DESC LIMIT 20 become : SELECT f_name, l_name, age FROM ( SELECT f_name, l_name, age, ROWNUM r FROM […]
Posted in db, prog | Tagged limit, oracle, sql |
By Chris on August 30, 2014
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 […]
Posted in db | Tagged boolean, oracle, pl/sql, sql |
By Chris on August 9, 2014
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 […]
Posted in db, prog | Tagged oracle, quote, single quote, sql |
Recent Comments