Oracle Table and Columns CamelCase

I have an old Oracle database that has camelcase table and columns.  I am having problems with SQLPro Studio processing data from the database.


SELECT * FROM MOLMAN.MinistoreCapacityHistory WHERE rownum <= 1000

ORA-00942: table or view does not exist (Line 1)

I can manually put quotes around the table name to get it to work.

SELECT * FROM MOLMAN."MinistoreCapacityHistory" WHERE rownum <= 1000

Now that the data is retrieved after putting quotes around the table I am attempting to update data inline, but when I select "Preview and Apply" I get the following error because the "Retrieved column is camelcase.

Could not find column 'Retrieved' on table 'MOLMAN."MINISTORECAPACITYHISTORY"'. Does your query include aliases? That can cause this issue.

Are there any preferences to have SQLPro Studio put quotes around tables and columns? Or do I need to change the entire database?

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 1 mth agoLast active
  • 8Views
  • 1 Following