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

1 vote264 views1 answer
Timestamp in sqlite
SQL
0 vote283 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
2 votes257 views6 answers
In in sql
SQL
0 vote255 views1 answer
Hive batch drop table
SQL
5 votes285 views4 answers
Upload database mysql command line
SQL
5 votes258 views1 answer
Oracle scan source ddl
SQL
-1 vote265 views1 answer
Window functions in sql
SQL
3 votes277 views2 answers
Sql not contains
SQL
0 vote252 views1 answer
Mysql into outfile with headers
SQL
1 vote253 views2 answers
How to check username in mysql command line
SQL