This query gives error messages…..any ideas why?



INSERT INTO my_employee

VALUES (&p_id, ‘&&p_last_name’, ‘&&p_first_name’,

lower(substr(‘&p_first_name’, , ) ||

substr(‘&p_last_name’, , )), &p_salary);



UNDEFINED p_first_name

UNDEFINED p_last_name

The statement to the above query was: Write and insert statement in a dynamic reusable script file named loademp.sql. to load rows into the my_employee table. Concatenate the first letter of the first name and the first seven characters of the last name to produce the user ID.


says missing or invalid options (?)

✅ Answers

🥇 Favorite Answer

  • Not a PHP expert by any means, but you use single & as a prefix in some spots and a double & in others, which looks suspicious to me.

  • I do think of if the call is blatantly incorrect, then definite, the umpire must be held to blame. in spite of the undeniable fact that admittedly there are some calls that for the time of sluggish action that’s ordinary to work out the overlooked call yet in genuine velocity that’s totally confusing to tell. i might supply them leeway on the very, very close bang bang performs, yet there must be some disciplinary action for blatantly incorrect calls, alongside with balls and strikes. I additionally think of if the umpire ejects a participant or supervisor from the interest over a overlooked call, the call must be reviewed, and taking into attention how close the call became or wasn’t, if the umpire became incorrect, and additionally taking into attention how the umpire dealt with the region, the ump must be suspended for no less than a million or video games, if not extra *cough* Joe West *cough*.

    See also  Hi guys this program is giving a runtime error in Java...The code is full correct and no compilation error?
  • Leave a Comment