PL/SQL retrieve from VIEW and Update Table ?? How?

[Delphiwhat]

Guys

I don't know if this is the correct form to ask this but i couldn't find a PL/SQL one! so maybe someone can help.

What I am trying to do is retrieve data from a VIEW and update this data into another TABLE.

When I have got this working manually i will need to CRON it as an automated script.


Can anyone show mw an example script of how i can do this? I am only familiar with limited PL/SQL basics.

not sure if i need to use procedures, scripts or?

Thanks for your help

steve

 

[SantaMufasa]

I am trying to...retrieve data from a VIEW and update this data into another TABLE.

...which makes me believe you have already composed some code. Could you please post that code here? Also, is there a reason you are using PL/SQL versus straight SQL?


Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[sem]

And is there reason you're going to use cron but not Oracle native jobs scheduled by dbms_job package?

Regards, Dima

http://seminihin.narod.ru

 

[Beilstwh]

INSERT INTO MY_TABLE
SELECT COL1,COL2,COL3,COL4,COL5
FROM MY_VIEW
WHERE COL1 = 'xyz';

Bill
Oracle DBA/Developer
New York State, USA