Introduction to the actual application code of Oracle variable binding

The following articles mainly use the actual application code to introduce the actual application of Oracle variable binding. I saw information about Oracle variable binding on the relevant website two days ago, the following is a detailed description of the article.

 
 

  
  
create table t (a varchar2(20),b varchar2(20)); 
 
 

Use Oracle to bind variables

 
 

  
  
declare  
  
  
v_sql varchar2(50);  
  
  
begin  
  
  
for i in 1..100000 loop  
  
  
v_sql := 'insert into t values (:1,:2)';  
  
  
execute immediate v_sql using 'a'||i,'b'||i;  
  
  
end loop;  
  
  
commit;  
  
  
end;  
  
  
/  
 
 

Clear table

 
 

  
  
truncate table t; 
 
 

Do not use Oracle to bind variables

 
 

  
  
declare  
  
  
begin  
  
  
for i in 1..100000 loop  
  
  
insert into t values ('a'||i,'b'||i);  
  
  
end loop;  
  
  
commit;  
  
  
end;  
  
  
/   
 
 

The above content is the description of Oracle variable binding, hoping to help you in this regard.