Prompt for variable in SQL Script

Simple tutorial on how to write a Oracle P-SQL script that asks user for a value in a prompt. /* — this script will update MLP identity across all related tables in LIMS correctly — — when executing in SQL navigator: — make sure the following is toggled on: — updateable, scan defines, spool outputs, […]