Website Construction Summary (Cont.)

  1. Entering Data into a Database
  2. SQL (Structured Query Language) is a standard language for accessing and manipulating databases. The following list shows an example of Oracle database processing, and the SQL commands are here:

    An Example of Oracle Database Processing
     undcemcs02> sqlplus C##user.id/password@//65.52.222.73:1521/cdb1 
    
     SQL*Plus: Release 12.1.0.2.0 Production on Wed Aug 17 11:04:42 2022
     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>

    The italic white text with a navy background color is entered by users.




      It is always darkest before the dawn.