sql - Oracle Stored Procedure Dynamic Query - How to add an extra column -

sql - Oracle Stored Procedure Dynamic Query - How to add an extra column -

i new oracle stored procedure , trying modify sp written else. should simple don't know how. here's sp's skeleton.

create or replace procedure mysp ( p1 in varchar2 , p2 in varchar2 , p3 in varchar2 , cur_s out sys_refcursor ) ... ...

and goes on build dynamically bunch of conditions, here's builds query:

my_query := 'select '|| column1_name || column2_name || ...

all queries fine, want do, add together column in select statement value p1, input parameter

i tried

my_query := 'select p1 newcolumnname '|| column1_name || column2_name ||

but not work. should do? thanks.

try this

my_query := 'select ''' || p1 || ''' newcolumn_name, ' || column1_name || column2_name ||

sql oracle stored-procedures