RE: FW: MySQL export and import into Oracle

2010-01-08 Thread machiel.richards
Thank you for the link but seeing that I am still new with MySQL , this does not mean anything to me. From: prabhat kumar [mailto:aim.prab...@gmail.com] Sent: 08 January 2010 4:22 PM To: machiel.richards Cc: mysql@lists.mysql.com Subject: Re: FW: MySQL export and import into Oracle http

Re: FW: MySQL export and import into Oracle

2010-01-08 Thread prabhat kumar
http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html#function_if On Fri, Jan 8, 2010 at 5:52 PM, machiel.richards wrote: > Hi guys, > > > > Can you please assist me in rewriting this query in order to run this > against a mysql database? > > > > It seems that the decode function do

FW: MySQL export and import into Oracle

2010-01-08 Thread machiel.richards
Hi guys, Can you please assist me in rewriting this query in order to run this against a mysql database? It seems that the decode function does not exist in mysql. select decode(nvl(receive_email, 'No'), 'Yes', 'Yes', 'No') email_corr, count(*) tot from profiles where email i