undcemcs02> sqlplus C##user.id/password@//65.52.222.73:1521/cdb1
SQL*Plus: Release 12.1.0.2.0 Production on Wed Aug 23 11:04:42 2023
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 -
64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real
Application Testing options
SQL> create table Students (
2 Name varchar(32) not null,
3 City varchar(16) not null,
4 Country varchar(16) not null );
Table created.
SQL> desc Students;
Name Null? Type
------------------------------- -------- -----------------------
NAME NOT NULL VARCHAR2(32)
CITY NOT NULL VARCHAR2(16)
COUNTRY NOT NULL VARCHAR2(16)
SQL> insert into Students values ( 'Alfreds Futterkiste',
2> 'Berlin', 'Germany' );
1 row created.
SQL> insert into Students values (
2> 'Berglunds snabbköp', 'Luleå', 'Sweden' );
1 row created.
SQL> insert into Students values (
2> 'Centro comercial Moctezuma', 'México D.F.', 'Mexico' );
1 row created.
SQL> insert into Students values (
2> 'Ernst Handel', 'Graz', 'Austria' );
1 row created.
SQL> insert into Students values (
2> 'Island Trading', 'Cowes', 'UK' );
1 row created.
...
SQL> select * from Students;
NAME CITY COUNTRY
-------------------------------- -------------- ----------------
Alfreds Futterkiste Berlin Germany
Berglunds snabbköp Luleå Sweden
Centro comercial Moctezuma México D.F. Mexico
Ernst Handel Graz Austria
FISSA Fabrica Inter. Salchichas Madrid Spain
Galería del gastrónomo Barcelona Spain
Island Trading Cowes UK
Königlich Essen Brandenburg Germany
Laughing Bacchus Wine Cellars Vancouver Canada
Magazzini Alimentari Riuniti Bergamo Italy
North/South London UK
Paris spécialités Paris France
Rattlesnake Canyon Grocery Albuquerque USA
Simons bistro København Denmark
The Big Cheese Portland USA
Vaffeljernet Arhus Denmark
Wolski Zajazd Warszawa Poland
17 rows selected.
SQL> commit;
SQL> exit;
Disconnected from Oracle Database 12c Enterprise Edition
Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real
Application Testing options
undcemcs02>
|