MySQL Forums
Forum List  »  Oracle

Re: mySQL to PL/SQL
Posted by: Nelson Padilla
Date: July 18, 2007 09:17PM

Sorry i pasted everything, I just need to convert this part...
Thanks again...

SET @SQL_stmt= CONCAT('SELECT DISTINCT tbl_batch_step_tool_user_submit.fld_id, tbl_batch.fld_batch_id
AS BatchID, tbl_batch.fld_name AS `Batch Name`, tbl_step.fld_name AS Step, tbl_user.fld_name
AS `User Name`, tbl_user.fld_user_id AS UserID, tbl_step.fld_step_id, tbl_batch_step_tool_user_submit.fld_date
AS `Date Append` FROM tbl_batch INNER JOIN tbl_batch_step_tool_user_submit
ON tbl_batch.fld_batch_id =tbl_batch_step_tool_user_submit.fld_batch_id INNER JOIN tbl_step
ON tbl_batch_step_tool_user_submit.fld_step_id=tbl_step.fld_step_id INNER JOIN tbl_user
ON tbl_batch_step_tool_user_submit.fld_user_id=tbl_user.fld_user_id
WHERE tbl_batch.fld_ver_id=', "'",ver_id, "'
AND (", where_clause, ' MID(fld_step_string_series, 50,1)=3)
AND tbl_batch_step_tool_user_submit.fld_date< DATE_SUB(Now(), INTERVAL 2 DAY);');
PREPARE stmt FROM @SQL_stmt;
EXECUTE stmt;

Options: ReplyQuote


Subject
Views
Written By
Posted
13398
July 18, 2007 08:29PM
Re: mySQL to PL/SQL
4803
July 18, 2007 09:17PM
4627
April 24, 2009 10:17PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.