Hi, before I begin for context I am a computer science student trying to complete an assignment so bare with me if I make errors or if I'm confused at what you may think as simple, thank you for understanding.
With that out of the way it is as the title says, I constantly get the “SQL command not properly ended” error. I am getting it for simple things like selecting a table like SELECT * FROM A1_DEPARTMENT; I even get it when trying to display the date with SELECT sysdate FROM dual;
SELECT sysdate FROM dual;
Error at Command Line : 130 Column : 1
Error report -
SQL Error: ORA-00933: SQL command not properly ended
00933. 00000 - "SQL command not properly ended"
I have even tested it by doing SELECT * FROM A1_EPARTMENT; (missing the D from DEPARTMENT) and I don't get a different error just the same one I always get. I am utterly confused why this is happening, I have seen other similar posts however their problem was missing the semicolon after the command which is not the case with me. The extremely odd thing is I was able to create a VIEW and then display that VIEW but everything after those few lines of code just does not work and produces the same error EVERY SINGLE TIME.
This is extremely frustrating and I would greatly appreciate it if someone could shed light on what is happening here and how I could fix this. Thanks