What does the colon sign “:” do in a SQL query?

by

What does “:” stand for in a query?

A bind variable. Bind variables allow a single SQL statement (whether a query or DML) to be re-used many times, which helps security (by disallowing SQL injection attacks) and performance (by reducing the amount of parsing required).

How does it fetch the desired value?

Before a query (or DML) is executed by Oracle, your program will create a cursor. Your program issues the SQL to be parsed for that cursor, then it must bind values for each bind variable referred to by the SQL. How this is done depends on the language.

What is that sign called?

A colon.

More Related Contents:

  1. Receive an unexpected symbol error in my PLSQL query [closed]
  2. PL SQL UPDATE STATEMENT
  3. Splitting string into multiple rows in Oracle
  4. Search All Fields In All Tables For A Specific Value (Oracle)
  5. What is the string concatenation operator in Oracle?
  6. Is it possible to output a SELECT statement from a PL/SQL block?
  7. SQL recursive query on self referencing table (Oracle)
  8. How can you tell if a value is not numeric in Oracle?
  9. PLS-00428: an INTO clause is expected in this SELECT statement
  10. passing table and column name dynamically using bind variables
  11. SQL error “ORA-01722: invalid number”
  12. Is there any way to flush output from PL/SQL in Oracle?
  13. Array in IN() clause oracle PLSQL
  14. PLSQL Insert into with subquery and returning clause
  15. Different CURRENT_TIMESTAMP and SYSDATE in oracle
  16. How to query a CLOB column in Oracle
  17. Oracle (Old?) Joins – A tool/script for conversion?
  18. How to return multiple rows from the stored procedure? (Oracle PL/SQL)
  19. Issue when comparing result of to_char(myDate, ‘DAY’) to a string
  20. Advice Using Pivot Table in Oracle
  21. In Oracle, is it possible to INSERT or UPDATE a record through a view?
  22. Creating or simulating two dimensional arrays in PL/SQL
  23. How to handle optional parameters in SQL query?
  24. Oracle- Split string comma delimited (string contains spaces and consecutive commas)
  25. How to use Alias in Where clause? [duplicate]
  26. How to check if a column exists before adding it to an existing table in PL/SQL?
  27. Subtracting Dates in Oracle – Number or Interval Datatype?
  28. How to call Oracle MD5 hash function?
  29. ORACLE After update trigger: solving ORA-04091 mutating table error
  30. Using bind variables with dynamic SELECT INTO clause in PL/SQL

Leave a Comment