i have table students it contains columns (sid,sname,status) automatically inserts the row from students table to students_history table whenever im updating status column into 'completed ' in students table.pls wrire query for this using jobs
First this forum is for the SQLDeveloper tool, and yours is a generic PL/SQL question.
Anyway you seem to be in need of a trigger more than a job.
Please don't post your homework assignments in the forums.
The forums are NOT coding services. If you need someone to write queries for you you should hire a developer.