Truncate a table then insert data

create or replace procedure myProcedure
AS
BEGIN
    execute immediate 'truncate table Event_name';    
    insert into Event_name select * from Event_name;
END;

Source: stackoverflow.com

Similar codes

0 vote337 views1 answer
Max length found in mysql
SQL
0 vote296 views1 answer
Mysql sleep connections
SQL
22 votes400 views1 answer
Mysql workbench
SQL
0 vote382 views1 answer
Kimball data warehouse sql calendar
SQL
0 vote341 views1 answer
How to see password mysql vestacp
SQL
2 votes324 views1 answer
How to get weekday from old date in sql
SQL
22 votes318 views4 answers
Tsql rename table
SQL
0 vote307 views1 answer
Redirection 301 htaccess nom de domaine
SQL
10 votes338 views3 answers
Join multiple tables sql
SQL
0 vote315 views1 answer
How to query all tables mysql at the same time
SQL