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 vote217 views1 answer
Sql datediff month
SQL
3 votes313 views1 answer
How to get yesterday date in sql
SQL
2 votes217 views1 answer
Mysql sysdate - 1 day
SQL
4 votes224 views2 answers
Oracle unlock user
SQL
1 vote227 views1 answer
Mysql current running queries
SQL
0 vote250 views1 answer
Sql quary stuf
SQL
1 vote221 views1 answer
Check if mysql is installed
SQL
15 votes215 views4 answers
How to get all tables in sql
SQL
1 vote235 views1 answer
Oracle check table lock
SQL
1 vote206 views2 answers
Mysql trim whitespace
SQL