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 vote171 views1 answer
Join in update query in mysql
SQL
19 votes207 views3 answers
How to change column type psql
SQL
0 vote180 views1 answer
Rename constraint postgresql
SQL
0 vote204 views2 answers
Get value from a table an insert it with other values in another table sql
SQL
0 vote184 views1 answer
Original Query
SQL
13 votes203 views4 answers
Command line mysql import
SQL
1 vote181 views1 answer
Change table to innodb mysql
SQL
0 vote188 views1 answer
Oracle procedure teamplate
SQL
0 vote192 views1 answer
Postgresql comandos basicos
SQL
1 vote176 views3 answers
Epoch to datetime
SQL