Oracle's binding variables

Binding Variables (binding variable), shared pool (pooled buffer pool), SGA(System global Area);

Role: The SQL should be analyzed into soft analysis, reducing the resources and time spent on hard analysis.

Java uses bound variables:

Bulk Delete SQL by ID

String sqlString = "Delete from Ivf_incubator_setting_d IfD where ifd.incubator_setting_h_id in (:foreignid)";
Query query = Getentitymanager (). Createnativequery (sqlString);
string[] id = ids.split (",");

Return Query.unwrap (Sqlquery.class). setparameterlist ("Foreignid", id). executeupdate ();

Delete Hql by ID

@Override
public int Removeentitybyid (class<?> clazz, Serializable ID) {
StringBuilder JPHL = new StringBuilder ();
Jphl.append ("DELETE from"). Append (Clazz.getsimplename ());
Jphl.append ("D WHERE d.id=:entityid");
Return Getentitymanager (). CreateQuery (Jphl.tostring ()). Setparameter ("EntityId", id). executeupdate ();
}

SGA: The system global Zone, which includes the data buffer zone, redo log area, and shared pool, is the area of memory shared by all user processes.

Oracle's binding variables