bind-variables
Declaration of multiple values in Oracle BIND Variables
I am trying to pass multiple values about 3000 values, to a BIND variable in Oracle SQL PLUS command prompt like..[详细]
2023-03-19 12:38 分类:问答Java prepared statement parameters for oracle alter session query
I tried executing the oracle alter session query for changing the language settings but it fails with an error \"ORA-01036: illegal variable name/number\".[详细]
2023-02-21 02:27 分类:问答Selecting float number from FLOAT() column with PHP and mysqli
Good day. I have a problem with selecting float number from MySQL database using bind variables of mysqli class.[详细]
2023-02-18 05:12 分类:问答How to inline a variable in PL/SQL?
The Situation I have some trouble with my query execution pl开发者_运维知识库an for a medium-sized query over a large amount of data in Oracle 11.2.0.2.0. In order to speed things up, I introduced a[详细]
2023-02-18 04:42 分类:问答use of bind variable
Can we use a bind variable in oracle inside a procedure or function ? I\'m trying to update a bind variable inside my procedure. Can I do so in any case?[详细]
2023-02-14 22:05 分类:问答ExecuteReader with Oracle array binding
I\'m trying to improve performance of my Oracle SQL queries by using array binding to an OracleParameter.[详细]
2023-01-10 06:38 分类:问答Oracle SQL trace with bind variables
How to aquire the full SQL statement with bind variables substituted from a trace file? When setting ALTER SESSION SET EVENTS \'10046 trace name context forever, level 4\';[详细]
2023-01-05 13:14 分类:问答passing value of sqlplus variable from one script to another
I have a script that gets the current time, and must pass it to another script. variable v_s_time varchar2(30);[详细]
2022-12-26 17:13 分类:问答What does the colon sign ":" do in a SQL query?
What does : stand for in a query? INSERT INTO MyTable (ID) VALUES (:myId) How does it fetch the desired value?[详细]
2022-12-18 23:26 分类:问答PLSQL not all variables bound
i keep getting the following errror, \'ORA-01008: not all variables bound\', im guessign its all based on my pPostcode param but im not sure.[详细]
2022-12-18 12:17 分类:问答