Guys I need to convert a data type date and another type varchar to string type and then both are in string type concatenate them. Can I do that in plsql ???
Guys I need to convert a data type date and another type varchar to string type and then both are in string type concatenate them. Can I do that in plsql ???
Sure. No problems:
> select to_char(sysdate, 'dd/mm/yyyy') || ' un dato tipo varchar'
from dual;
Example, if you have a table like this:
> create table a (d date, v varchar2(200);
Your query may be:
> select to_char(d, 'dd/mm/yyyy') || v
from a;
In PL / SQL it would be as straightforward as declaring a cursor with this query, and iterating it to a varable type varchar2 .