MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
set the value of AS clause name in stored procedure
1056
Terry Warren
December 24, 2020 05:10PM
Re: set the value of AS clause name in stored procedure
452
Peter Brawley
December 24, 2020 06:49PM
Re: set the value of AS clause name in stored procedure
483
Terry Warren
December 25, 2020 08:21AM
Re: set the value of AS clause name in stored procedure
438
Peter Brawley
December 25, 2020 11:08AM
Re: set the value of AS clause name in stored procedure
503
Terry Warren
December 26, 2020 08:43AM


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.