...
| Code Block | ||||
|---|---|---|---|---|
| ||||
SQL> insert into country (country_id, country, continent, tld)
2 values (country_seq.nextval, 'Bermuda', 'Latin America', 'bm');
1 row created.
SQL> commit;
Commit complete;
SQL> exit;
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning and Real Application Testing options
52cottrell@pinger:~>
or
[cottrell@pinger ~]$ setenv ORACLE_HOME /usr/oracle
[cottrell@pinger ~]$ sqlplus iepm@slacprod
SQL*Plus: Release 11.1.0.6.0 - Production on Fri Jan 21 13:13:48 2022
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Enter password:
[cottrell@pinger ~]$ echo $ORACLE_HOME
/usr/oracle
[cottrell@pinger ~]$ setenv ORACLE_HOME /usr/oracle
[cottrell@pinger ~]$ sqlplus iepm@slacprod
SQL*Plus: Release 11.1.0.6.0 - Production on Fri Jan 21 13:32:15 2022
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
SQL> insert into country (country_id, country, continent, tld)
2 values (country_seq.nextval, 'Fiji', 'Oceania', 'fj');
1 row created.
SQL> commit;
Commit complete.
SQL> exit;
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
[cottrell@pinger ~]$
[cottrell@pinger ~]$ date
Fri Jan 21 13:40:21 PST 2022 |
The COUNTRY table is not used except by the list of values in the UI. Note that if a country name needs to be changed or if a country was placed in the wrong region, it must be updated on all the nodes in the NODEDETAILS table as well as on the COUNTRY table.
...