Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Update from Command prompt

584851Feb 17 2008 — edited Feb 19 2008
I'm trying to run update statements from a sql file where the data will be inputed by the user from the command prompt.

i tried putting this in my script
update table_1 set column_1 = &variable where column_2 = 'X';
commit;
exit;
/

when i ran it it didn't put enter value for variable it just put a blank line and i inputted the variable and the table was updated. but no prompt saying
enter value for variable came up.
how can i add that prompt so the user can know what to do?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 18 2008
Added on Feb 17 2008
13 comments
1,336 views