I'ven't tried this, but it purports to handle mySQL:
http://www.oracle.com/technology/tech/migration/migrationtoolsstatementofdirection.htm

There's the big migration thing in SQL Developer, but for easy conversion of just a procedure there's the "Translation Scratch Editor", listed under the "Migration" tab. Paste the other DBMS's code in the left window, click a button, and the Oracle equivalent appears in the right window. (I haven't used it for MySQL, but I have for SQL Server.)

It really transliterates the code rather than "converting" it, as you'd want to incorporate smart Oracle techniques that the other DBMS's code wouldn't have. It saves on the initial typing, though. I typed Iram's...

  select case_id as 'this is alias' from cases

...and it spat out:

  SELECT case_id "this is alias"
    FROM cases;

So the is SQL scattered around the application code, rather than condensed into a data access layer, or invoked through stored procedures?

Sounds like re-architecture time!

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:12083187196917#1753309400346975595

SELECT e.empid, e.logonid, e.title,
concat (e.first_name , ' ' , e.last_name)emp_name, e.dob, e.role_lookupid,
fnc_get_lookup_value ('Emp', 'Role', e.role_lookupid) role_value,
e.emp_is_dr_resource, e.release_date, p.MANAGERID,
FNC_GET_EMP_NAME(p.MANAGERID) manager_name, p.tlid,
FNC_GET_EMP_NAME(p.tlid) tlname, p.PLID,
FNC_GET_EMP_NAME(p.tlid) plname,e.emptype_lookupid,
fnc_get_lookup_value ('Emp','EmployeeType', e.emptype_lookupid) emp_type,
fnc_get_lookup_value ('Emp','WorkLoc', e.work_loc_lookupid) work_loc_value,
e.work_loc_lookupid, e.isactive, ep.prjid,
p.project_name, ep.work_bill_flag,e1.empid pm_id,
concat(e1.first_name, ' ',e1.last_name) pm_name, ec.extn,
p.prj_short_name,p.start_date, p.end_date,p.prj_static_folder,p.PROJECTSETUPCODE ,
p.prj_working_folder,
(select case when line_two is not null then concat(line_one,' ',line_two)
when city is not null then concat(line_one,' ',line_two,' ',city)
when state is not null then concat(line_one,' ',line_two,' ',city,' ',state)
when pincode is not null then concat(line_one,' ',line_two,' ',city,' ',state,' ',pincode)
ELSE line_two END as home_addr
FROM emp_client_address
WHERE emp_client_id =e.empid
AND addr_entry_type = 'E'
AND addresstype_lookupid = 43) address , e.first_name, e.last_name
FROM emp_mst e, emp_mst e1, emp_prj_dets ep, prj_mst p, emp_contact_info ec ;
WHERE UPPER (e.logonid) = UPPER ('arun')
AND e.isactive = 'T'
AND ep.empid = e.empid
AND p.prjid = ep.prjid
AND nullif(ep.work_bill_flag='W','') IN ('B', 'W')
AND e1.empid = p.MANAGERID
AND ec.empid = e.empid
AND ec.contact_type_lookupid = '55'
AND ep.primary_project = 'Y'
AND p.prjid = ep.prjid;

Guys,

I have seen time and again people posting without any description of the problem, create statements, examples or any basic information. Please don't treat asktom as an entitlement (lack of better word) rather, it is a privilege to get a response from Tom. He takes time from his busy schedule to answer our questions. He doesn't have to answer questions without any details what-so-ever but he still does. Show respect for his time and provide as much details as you can. Tom doesn't know our business, schema, design or code. It is our duty to give the information if we need quick answer. Tom will ask you if he needs more info.

My 2c.

-Ravi