MySQL Forums
Forum List  »  Oracle

Oracle ACCEPT Keyword in Mysql
Posted by: Palash Chatterjee
Date: November 02, 2009 11:44PM

I am new to Mysql,
I was wondering how the ACCEPT keyword of Oracle SQL script will be replaced
in Mysql script, So that user will be asked for runtime input during execution

*******************
ACCEPT Colx PROMPT'Please enter column name:'
ACCEPT cond PROMPT'Please enter lowest salary value:'
SELECT empno, eName, &Colx
FROM Emp
WHERE &Colx > &cond
ORDER BY &Colx;
*******************

regards,
Palash

Options: ReplyQuote


Subject
Views
Written By
Posted
Oracle ACCEPT Keyword in Mysql
4543
November 02, 2009 11:44PM


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.