SQL help using Oracle Database - NOT MYSQL OR MICROSOFT SQL SERVER! Syntax matte

Question

SQL help using Oracle Database - NOT MYSQL OR MICROSOFT SQL SERVER! Syntax matters

I'm not allowed to use BEGIN/END statements (don't even know what that means he hasn't taught us that yet)

Please don't mark it as "Needs more Info" because this is all of the info I have received to do this.

Link to question if you can't see the image below: http://i.imgur.com/5iZzwa0.png

This is what I have so far but it doesn't execute because of the 'INSERTNAMEHERE', I'm not sure what the proper syntax that would be compatible with the nOracle Database syntax would be to fix this, please help. Link if you can't see: http://i.imgur.com/TwFr2WW.png

Thank you.

Explanation / Answer

There is nothing wrong with your code. Your code should work by all means. Just use double quotes(") instead of single quotes. And if it still doesn't work, try executing on another machine. Syntactically, your query is 100% correct.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.