Example:
Str_sql:='insert into sem_108 values (: v_id, v_name);
Dbms_output. Put_line (v_id);

When using the test window can input v_id and v_name, but I don't know what v_id and v_name method is coming, is through the JAVA binding in this function and then pass the value?

CodePudding user response:

Java has a parameterized method directly, you first baidu once, can't find the words, I give you to move to Java area,

PS: oracle can use

The execute immediate STR using 100, "zhangsan";

CodePudding user response:

The statement, variable into just go directly, through prepareStatement way? Data binding by value

CodePudding user response:

JAVA development does not use the framework, the dynamic parameters of SQL statements are basically joining together,