Hi all ,
I have a table where I maintain name value pairs of a particular job . Now I would like see some of value of this rows passed to other rows in a table for example
create job_name_value
(
job_name varchar2(100),
name varchar2(100),
value varchar2(100)
);
| job_name | name | value |
|---|
| TRGJOB | %FPATH | /USR/LOCAL/TRGJOB |
| TRGJOB | %FDATE | CALDATE+1 |
| TRGJOB | %FNAME1 | %FPATH.mywatchfile1.%FDATE |
| TRGJOB | %FNAME2 | %FPATH.mywathcfile2.%FDATE |
| TRGJOB | %FNAME3 | %FPATH.mywatchfile3.%FDATE |
| | |
| | |
can we write a sql query to produce a output like below the objective is use the value of fdate and fpath in the remaining rows . if there is no fdate and fpath then the value should return as it is or we need to use stored proc to achieve this
/usr/local/trgjob/mywatchfile1.CALDATE+1
/usr/local/trgjob/mywatchfile2.CALDATE+1
/usr/local/trgjob/mywatchfile3.CALDATE+1