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

3 votes320 views1 answer
Locate sql server
SQL
0 vote296 views1 answer
Contact mysql column field
SQL
0 vote294 views1 answer
Laravel eloquent get generated sql
SQL
0 vote318 views1 answer
SQL column name Oracle
SQL
19 votes305 views6 answers
What is mySQL
SQL
1 vote335 views1 answer
How to put value in variable mysql
SQL
7 votes316 views5 answers
Sql remove spaces
SQL
0 vote296 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
0 vote312 views1 answer
Get schema of table sql
SQL
0 vote298 views1 answer
NLS_NCHAR_CHARACTERSET
SQL