I am using TOAD version 11.0. I am new to the process
In the database, I want to refresh a table (Suppose Emp) automatically by dropping it manually and then recreate the same table from another table (Main_emp)
drop table emp;
create table emp as select * from Main_emp;
Is it possible to run the above two line automatically daily at 9 am.