SQL query in CRONTAB

[Indira Aramandla]

I am sending an attachment as an example. Hope this helps.


Indira

[Yogeeraj_1]

hi Christian,

For the changes you are requesting, i think it will be preferable to create a view and use the script i sent you - This will not incur any changes in the scripts!

E.g.
create or replace view v_equipoid_101 as
select nombreequipo from equipo where idtipoequipo=101;

then use argument "v_equipoid_101" to the "flat" script!

Let me know if ok.

Also, if you post additional information on what you are planning to with the file, maybe i can suggest other alternatives.

Hope this help!

Best Regards
Yogeeraj