SELECT NAME FROM ABCD WHERE NAME LOVE "+ aero +%" AND ROWNUM <= 10

Question

CHOOSE A NAME FROM ABCD WHERE A NAME LOVES "+ aero +%" AND ROWNUM <= 10

what is the syntax error in this line ...... SELECT NAME FROM ABCD it works

Answer 1

You need single quotes:

SELECT NAME FROM ABCD WHERE NAME LIKE '+aero+%' AND ROWNUM <= 10

And also a space before AND.

UPDATE

In your question it is not clear what exactly you are looking for. Instead, one of the following actions may be required:

SELECT NAME FROM ABCD WHERE NAME LIKE '"+aero+%"' AND ROWNUM <= 10

SELECT NAME FROM ABCD WHERE NAME LIKE '%"+aero+"%' AND ROWNUM <= 10

SELECT NAME FROM ABCD WHERE NAME LIKE '"%+aero+%"' AND ROWNUM <= 10

... or some other options. But the important thing is that you must pass literals with single quotes, not double quotes.

Answer 2

EDIT:

con.prepareStatement(
    "SELECT name FROM abcd WHERE name LIKE '" + aero + "%' AND ROWNUM <= 10");

, aero.

, aero,

con.prepareStatement(
    "SELECT name FROM abcd WHERE name LIKE '%" + aero + "%' AND ROWNUM <= 10");

---

:

SELECT name
FROM abcd
WHERE name LIKE '+aero+%'
  AND ROWNUM <= 10;

, , '"+aero+%"'.

, aero, '%aero%'.

Answer 3

?

AND?

Answer 4

.

Answer 5

, , aero - , % . aero ab, 'ab','abc', 'abcd', .......

"SELECT NAME FROM ABCD WHERE NAME LIKE '"+aero+"%' AND ROWNUM <= 10;"

Answer 6

, aero 'aero' . , :

pr = con.prepareStatement
         ("SELECT NAME FROM ABCD WHERE NAME LIKE 'aero%' AND ROWNUM <= 10");

, . , , SQL-. ASP, :

pr = con.prepareStatement
         ("SELECT NAME FROM ABCD WHERE NAME LIKE ?||'%' AND ROWNUM <= 10");
con.setString(1,aero);