Oracle SQL Error: How to Debug this issue

Answer 1

SELECT *
FROM   ALL_TAB_COLS
WHERE  UPPER(COLUMN_NAME) = 'NAME';

will show you all columns called NAME

EDIT:

Based on your comment, aren't you missing the operators in your WHERE clause? ie =

select name, id
from   "TEST"
where  id :2      -- Surely you mean: id = :2
AND name :1       -- Surely you mean: name = :2
order by id desc

EDIT 2:

Based on the SQL*Plus output, it looks like you've created the table with lower-case column names. Whilst this is possible and valid it's usually just hard work. I'd recreate the columns with upper case names. (as Alex said)

EDIT 3:

I think...

SELECT "id", "name"
FROM   TEST
WHERE  "id" = :1
AND    "name" = :2
ORDER BY "id" desc;

should work

Answer 2

It's a good idea not to surround column and table names with double-quotation marks unless you are know what you are doing and confident you need that.

In Oracle, database object names (including table and columns) are not case-sensitive and assumed upper-case unless you include them into double-quotes.

E.g, if a table created as TEST, it can be referred to as test, Test or TesT or "TEST". But if it is created as "Test", you will only be able to refer to it as "Test" (in double quotation marks). All the other ways will result in "invalid identifier" error.