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 vote200 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
0 vote367 views1 answer
The differnece between to values in sql
SQL
0 vote225 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
0 vote235 views1 answer
Linebreak sql
SQL
0 vote210 views1 answer
Automate mysql cli query
SQL
0 vote219 views1 answer
Add plugins to mysql workbench
SQL
0 vote219 views1 answer
Difference between varchar and varchar2
SQL
0 vote255 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
0 vote243 views1 answer
Alter table engine mysql
SQL
1 vote211 views1 answer
Update from select join
SQL