create or replace procedure myProcedure
AS
BEGIN
execute immediate 'truncate table Event_name';
insert into Event_name select * from Event_name;
END;
Code Example |
---|
Sql :: add column first position mysql |
Sql :: how to declare variable date in mysql |
Sql :: SQL Server date literal |
Sql :: Create parameterized VIEW in SQL Server |
Sql :: grapgql |
Sql :: convert Date to LocalDate via SQLDate |
Sql :: denormalization in sql example |
Sql :: postgresql show tables |
Sql :: sql min |
Sql :: mysql in clausule string array |
Sql :: long string type sql |
Sql :: pl sql command line run |
Sql :: sql like with multiple values |
Sql :: MySQL error code 2068 |
Sql :: remove duplicates mysql |
Sql :: order by postgres |
Sql :: mysql large import |
Sql :: get substract count sql |
Sql :: mysql write into table |
Sql :: postgresql add not null and not empty constraint |
Sql :: how to get capital letter first in sql |
Sql :: connect mysql |
Sql :: stuff in sql |
Sql :: rename command in sql |
Sql :: join multiple tables in sql same table |
Sql :: how to create notes in mysql |
Sql :: drop all tables db2 |
Sql :: oracle activate program |
Sql :: cube oracle |
Sql :: consulta alias con inner join |