MySQL Forums
Forum List  »  Stored Procedures

set the value of AS clause name in stored procedure
Posted by: Terry Warren
Date: December 24, 2020 05:10PM

is it possible to set the column heading within a stored procedure SELECT statement to the value of an input variable? For example using the stored procedure definition:

PROCEDURE sp_sample(IN ex_value CHAR(32))
BEGIN
SELECT some_col AS XXX ...

I want to assign the value passed in as ex_value to the column heading XXX

Options: ReplyQuote


Subject
Views
Written By
Posted
set the value of AS clause name in stored procedure
183
December 24, 2020 05:10PM


Sorry, only registered users may post in this forum.

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.