Prihlaseni:

aisa:zriha$ module add oracle
aisa:zriha$ sqlplus

SQL*Plus: Release 8.1.5.0.1 - Production on Mon Feb 24 20:34:40 2003

(c) Copyright 1998 Oracle Corporation.  All rights reserved.

Enter user-name: u0000
Enter password:

Connected to:
Oracle8i Enterprise Edition Release 8.1.5.0.1 (64-bit) - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.1 - Production

SQL>

Prace s sqlplus:

Manual k SQL*Plus (v HTML) je na strance predmetu.
Nejlepsi je vytvorit si v oblibenem textovem editoru soubor s priponou
.sql (napr. cv1.sql) a v sqlplus jej spustit prikazem "@cv1".

Zmena hesla:

Prikaz password:

SQL> password
Changing password for U0000
Old password:
New password:
Retype new password:
Password changed

Nebo prikazem alter user:

SQL> alter user u0000 identified by "1 2";

User altered.

Vytvoreni tabulky:

CREATE TABLE schema.table (column datatype [DEFAULT expr], ...);

Datove typy:

char(size) - retezec fixni delky o velikosti size; size nejvyse 2000
varchar2(size) - retezec variabilni delky, maximalne o velikosti size, pricemz 
                 size je nejvyse 4000
long - retezec o velikosti az 2GB
raw(size) - binarni data o velisti size
blob - binarni data, maximalne 4GB
date - datum (defaultne tvar DD-MON-YY)
number(precision, scale) - cislo s platnymi ciframi p (1-38), zaohrouhlene na
rozsah s (-84 az 127)
integer,int =number(38)
float(size), double precision, real - realna cisla (ekvivalentni s NUMBER)

Actual     Specified As Stored As
7456123.89 NUMBER       7456123.89
7456123.89 NUMBER(9)    7456124
7456123.89 NUMBER(9,2)  7456123.89
7456123.89 NUMBER(9,1)  7456123.9
7456123.89 NUMBER(6)    exceeds precision
7456123.89 NUMBER(7,-2) 7456100
7456123.89 NUMBER(-7,2) exceeds precision

Actual      Specified As Stored As
.01234      NUMBER(4,5) .01234
.00012      NUMBER(4,5) .00012
.000127     NUMBER(4,5) .00013
.0000012    NUMBER(2,7) .0000012
.00000123   NUMBER(2,7) .0000012

Priklad: 
SQL> create table cd (id number, nazev varchar2(50), datum date, rating float);
Table created.

Vkladani dat do tabulky:

insert into schema.table [(columns)] values (...);

Priklad:


SQL> insert into cd values (1, '9mm', '02-JAN-02', 9.5);

1 row created.

Uprava dat v tabulce:

update schema.table set column=expr where ...;


Priklad:

SQL> update cd set rating=7.5 where id=1;

1 row updated.

Mazani dat z tabulky:

delete from schema.table where ...;

Priklad:

SQL> delete from cd where id=1;

1 row deleted.

Smazani tabulky:

drop table schema.table;

SQL> drop table cd
  2  ;

Table dropped.

Poznamky v SQL:
Jeden radek: "--" na zacatku radku znamena ignorovani tohoto radku.
Jinak funguji komentare jako v C-ecku tj. Zacatek "/*" a konec "*/".