log3

SQL> connect system/password
Connected.
SQL> grant alter on tablica to polzovatel;

Grant succeeded.

SQL> connect polzovatel/parol;
Connected.
SQL> set timing on;
SQL> alter table system.tablica add chislo2 number(3,0);

Table altered.

Elapsed: 00:00:00.24
SQL> update system.tablica
2 set chislo2=mod(1+4+33,17)
3 where chislo=52;

1 row updated.

Elapsed: 00:00:00.22
SQL> update system.tablica
2 set chislo2=mod(2+4+33,17)
3 where chislo=53;

1 row updated.

Elapsed: 00:00:00.06
SQL> update system.tablica
2 set chislo2=mod(3+4+33,17)
3 where chislo=54;

1 row updated.

Elapsed: 00:00:00.03
SQL> update system.tablica
2 set chislo2=mod(4+4+33,17)
3 where chislo=55;

1 row updated.

Elapsed: 00:00:00.01
SQL> update system.tablica
2 set chislo2=mod(5+4+33,17)
3 where chislo=56;

1 row updated.

Elapsed: 00:00:00.01
SQL> select * from system.tablica;

CHISLO STROKA
---------- --------------------------------------------------
STROKA2
--------------------------------------------------
STROKA3
--------------------------------------------------
STROKA4 CHISLO2
-------------------------------------------------- ----------
52 a
s
d
f 4


CHISLO STROKA
---------- --------------------------------------------------
STROKA2
--------------------------------------------------
STROKA3
--------------------------------------------------
STROKA4 CHISLO2
-------------------------------------------------- ----------
53 z
x
c
v 5


CHISLO STROKA
---------- --------------------------------------------------
STROKA2
--------------------------------------------------
STROKA3
--------------------------------------------------
STROKA4 CHISLO2
-------------------------------------------------- ----------
54 qw
er
ty
yu 6


CHISLO STROKA
---------- --------------------------------------------------
STROKA2
--------------------------------------------------
STROKA3
--------------------------------------------------
STROKA4 CHISLO2
-------------------------------------------------- ----------
55 as
df
fg
gh 7


CHISLO STROKA
---------- --------------------------------------------------
STROKA2
--------------------------------------------------
STROKA3
--------------------------------------------------
STROKA4 CHISLO2
-------------------------------------------------- ----------
56 rt
yu
ui
io 8


Elapsed: 00:00:00.17
SQL> select max(chislo2) from system.tablica;

MAX(CHISLO2)
------------
8

Elapsed: 00:00:00.05
SQL> select min(chislo2) from system.tablica;

MIN(CHISLO2)
------------
4

Elapsed: 00:00:00.01
SQL> select sum(chislo2) from system.tablica;

SUM(CHISLO2)
------------
30

Elapsed: 00:00:00.04
SQL> select stddev(chislo2) from system.tablica;

STDDEV(CHISLO2)
---------------
1.58113883

Elapsed: 00:00:00.09
SQL> delete from system.tablica where mod(chislo2,2)=0;

3 rows deleted.

Elapsed: 00:00:00.23
SQL> select * from system.tablica;

CHISLO STROKA
---------- --------------------------------------------------
STROKA2
--------------------------------------------------
STROKA3
--------------------------------------------------
STROKA4 CHISLO2
-------------------------------------------------- ----------
53 z
x
c
v 5



CHISLO STROKA
---------- --------------------------------------------------
STROKA2
--------------------------------------------------
STROKA3
--------------------------------------------------
STROKA4 CHISLO2
-------------------------------------------------- ----------
55 as
df
fg
gh 7


Elapsed: 00:00:00.11
SQL> set timing off;
SQL> spool out;