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 vote118 views1 answer
Oracle search columns in schema
SQL
0 vote123 views2 answers
How to update date in oracle
SQL
3 votes143 views3 answers
Update con select postgresql
SQL
0 vote125 views1 answer
Plpgsql raise notice
SQL
4 votes119 views2 answers
Sql table
SQL
2 votes118 views1 answer
Sql server find table name
SQL
0 vote155 views1 answer
SQL Cut part string
SQL
0 vote128 views1 answer
Find most frequent value in SQL column
SQL
0 vote125 views1 answer
MySql get primary keys of table
SQL
0 vote174 views1 answer
Selecting specific day in colum sql
SQL