If we want to update a single field or many fields of a row from a particular table, then we need to use the UPDATE command. It can modify single or multiple fields at a time.
Create oracle_06.sh to update the name of the specified ID:
#!/bin/bash sqlplus user1/Test123 <<MY_QUERY set serveroutput on; UPDATE Writers SET Name = 'demoname' WHERE Id = 101; select * from Writers; MY_QUERY
Save the script and run it as follows:
$ chmod +x oracle_06.sh $ ./oracle_06.sh
The output will be:
SQL*Plus: Release 220.127.116.11.0 Production on Mon Apr 30 18:08:52 2018 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 18.104.22.168.0 - 64bit Production With the Partitioning, OLAP, ...