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 vote396 views1 answer
Select * from mysql.proc
SQL
0 vote332 views1 answer
Sql server separar numeros por comas miles
SQL
0 vote338 views1 answer
Oracle execute package dblink
SQL
2 votes354 views6 answers
Mysql change timezone
SQL
1 vote341 views1 answer
Oracle stop
SQL
0 vote314 views1 answer
Deny select insert update delete sql
SQL
0 vote313 views1 answer
How to count with except in psql
SQL
-1 vote356 views5 answers
Convert sql to linq query online
SQL
0 vote367 views2 answers
Unique key
SQL
2 votes339 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL