Unanswered: update salary to 3000 if salary is less than 3000 (was "pl/sql"
i'm really new to PL and need help. here is a question i need help with "Write a PL/SQL code to update salary of employee whose employee number is ‘7788’ to 3000 if salary is less than 3000"
Can you do that using SQL? If so, just enclose that code into the BEGIN-END keywords and you'll have a PL/SQL code. Because, having all those values hard-coded, there will be no difference between SQL and PL/SQL solution.
If you, however, have a problem doing it, do post what you have done so far and someone will surely help you.
Have a look at the PL/SQL documentation first, there are many examples there that will help you. Then try to write something by yourself and come back with your code if you don't get it to work : paste your code and the exact error you get.
Then maybe someone will help you here, but noone will do your homework for you .
ORA-000TK : No bind variable detected... Shared Pool Alert code 5 - Nuclear query ready .