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  Word to XML conversion using word template?
  • Other Related Questions

    Learning Visual Basic ?

    Answers Favorite AnswerTry using "System.Diagnostics.Process. GetProcessesByName( "iwmp" ).Length > " for your check.

    Microsoft Office word Fast answer needed its urgent?

    Answers Favorite AnswerTry this: is another thread re: the same issue with instructions:

    Can I download a whole city android google maps?

    Answers Favorite Answer:) Yes!!!Interesting question. I wonder why it has blocked in this way especially considering that Google Earth is very detailed and has good maps of Israel.

    What is meant by ROM ? Explain in simple but elaborate terms.What about mobile ROM’s?

    Answers Favorite AnswerHi Diva below is a link that will give a simple answer. this helps.Source(s): Experience and wiki answers.ROM is Read only memory. i.e data can write only once.There two types of ROM..ROM.PROMThe difference between ROM and PROM.that is ROM is programmed during manufacturing it means data stored by manufacturing company.PROM is blank memory that a user programmable memory.user can store content on PROM.both ROM and PROM are Read only memory Data can write only once.and its not possible to write so many time.Memories of PROM and ROM are Non-volatile in nature. Its that stored informations can retain even power goes off.

    Leave a Comment