adspace


What is a parameter query?

Answer Posted / Alka

A parameterized query is a SQL query that uses placeholders for values that will be supplied at runtime. Parameterized queries are used to prevent SQL injection attacks by ensuring that user-supplied input is sanitized and escaped before being inserted into the query. Parameterized queries also improve performance because they can reuse execution plans across multiple queries with different parameters.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I remove duplicates in two columns?

1187


what is collation? : Sql dba

1229


how to start mysql server? : Sql dba

1267


Can delete statement be rollbacked?

1054


what is dbms? : Sql dba

1061


What is the best sql course?

1050


Is primary key always clustered index?

1095


what are the advantages of sql ? : Sql dba

1142


Can we rollback truncate?

1074


how many tables will create when we create table, what are they? : Sql dba

1144


Does group by remove duplicates?

1112


what are all the common sql function? : Sql dba

1131


how to escape special characters in sql statements? : Sql dba

1114


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2091


If a cursor is open, how can we find in a pl/sql block?

1238