CODEWITHSUNDEEP
sqldatabaseoracle-databasesqlplus
Irfan Ansari
Irfan Ansari

Reputation: 67

Errors in PL/SQL codes for "+"

This is my code from the Manual Code Image

Getting this error when I typed the code in "Run SQL Command Line" ERROR IMAGE

But when I copy pasted the same code line by line from my manual it got executed Executed Code

Even though both the codes are same, I'm getting the "+" error at the end. Tried spacing between the variables and ":=" but still getting the error when I write it. Why it's happening so?

THANKS IN ADVANCE..!

Upvotes: 0

Views: 59

Answers (1)

kevinskio
kevinskio

Reputation: 4551

In your error image you declare a variable called sum. This is an Oracle keyword and is the cause of the error.

If you change the name to sum1 as is shown in your sample it will run.

Upvotes: 4

Related Questions