QRACLE Database access (filter WHERE)

[oliver_r]

Hi

I am trying to access an oracle database. I can load the data using the standard scripting (e.g. LOAD Name_of_Field, SELECT 'Name_of_Field' FROM....).

But as as soon as I try to add a filter (WHERE 'Name_of_Field'=Value) I get an Error message:  "Field 'Name_of_Field' is not found.

Any idea what causes this? I have read only access to that database.

[Anil_Babu_Samineni]

Where you are trying?

SELECT 'Name_of_Field' FROM ...; // Single code means Static Row where as Double Quote help as field

Are you getting records using this? If so, You can define like

SELECT Name_of_Field FROM .. Where Name_of_Field = 'Value'; // Make sure, which value we are restricting?

Else, Still you can define like

DB Connection details...

LOAD Name_of_Field Where Name_of_Field = 'Value';

SELECT "Name_of_Field" FROM....;

[oliver_r]

Works now.

Seems that there was an issue on the Oracle Database side that was corrected. It works now exactly the way as specified.