Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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;
Comment

PREVIOUS NEXT
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 
ADD CONTENT
Topic
Content
Source link
Name
4+8 =