Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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....;
Works now.
Seems that there was an issue on the Oracle Database side that was corrected. It works now exactly the way as specified.