Re: set the value of AS clause name in stored procedure
Simplest possible example given table t(i,j)...
set @sql = "select i as 'first column',j as 'second column' from t";
prepare stmt from @sql;
execute stmt;
+--------------+---------------+
| first column | second column |
+--------------+---------------+
| 2 | 2 |
+--------------+---------------+
drop prepare stmt;
In your case you'd concat strings as required to assemble @sql.
Subject
Views
Written By
Posted
145
December 24, 2020 05:10PM
46
December 24, 2020 06:49PM
39
December 25, 2020 08:21AM
Re: set the value of AS clause name in stored procedure
42
December 25, 2020 11:08AM
32
December 26, 2020 08:43AM
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.