Alot of folks have problems when they first transfer to Oracle from MySQL.
Most of those problems are cosed by absence of LIMIT.
Just to give you all a hint in the right direction here is the simplest “pagination” query used on Oracle.
(select * from emp
where rownum

We had few problems with a huge database table (1600k rows of data). Basically problem was with invalid dates.
Our database is receiving data over serial port so there was Alot of garbage. Sice it’s such a huge table and there was so much invalid date formats I was forced to create decent Oracle replacement for [...]

Upravo sam okončao dvodnevne muke jedne male migracije sa Sybase na Oracle. Pošto sam se oslobodio svih frustracija samo ću uratko podeliti sa vama par stvari oko kojih sam se nervirao.

Interne funkcije
Primera radi sybase ima funkciju datepart() koja radi slično kao to_char() kod oracla, sada je to lepo i jednostavno kada znam, ali kada se [...]