Добавил:
Novilit
Опубликованный материал нарушает ваши авторские права? Сообщите нам.
Вуз:
Предмет:
Файл:lab3
.txt SQL> connect system/password
Connected.
SQL> connect new_user/password
Connected.
SQL> set timing on;
SQL> create table int_table(
2 number_pole NUMBER(11) NOT NULL,
3 key_pole VARCHAR(35) NOT NULL,
4 primary key (key_pole));
Table created.
Elapsed: 00:00:00.16
SQL> GRANT INSERT, UPDATE, DELETE on int_table TO new_user;
Grant succeeded.
SQL> grant select on int_table to new_user;
Grant succeeded.
Elapsed: 00:00:00.03
SQL> insert into int_table values (1, 'a');
1 row created.
Elapsed: 00:00:00.05
SQL> insert into int_table values (2, 'b');
1 row created.
Elapsed: 00:00:00.04
SQL> insert into int_table values (3, 'c');
1 row created.
Elapsed: 00:00:00.04
SQL> insert into int_table values (4, 'd');
1 row created.
Elapsed: 00:00:00.05
SQL> insert into int_table values (5, 'e');
1 row created.
Elapsed: 00:00:00.04
SQL> alter table int_table add number_pole2 number(5, 0);
Table altered.
Elapsed: 00:00:00.11
SQL> update int_table
2 set number_pole2=mod(1+13+33, 17)
3 where number_pole=1;
1 row updated.
Elapsed: 00:00:00.07
SQL> update int_table
2 set number_pole2=mod(2+13+33, 17)
3 where number_pole=2;
1 row updated.
Elapsed: 00:00:00.04
SQL> update int_table
2 set number_pole2=mod(3+13+33, 17)
3 where number_pole=3;
1 row updated.
Elapsed: 00:00:00.04
SQL> update int_table
2 set number_pole2=mod(4+13+33, 17)
3 where number_pole=4;
1 row updated.
Elapsed: 00:00:00.05
SQL> update int_table
2 set number_pole2=mod(5+13+33, 17)
3 where number_pole=5;
1 row updated.
Elapsed: 00:00:00.05
SQL> select * from int_table
2 ;
NUMBER_POLE KEY_POLE NUMBER_POLE2
----------- ----------------------------------- ------------
1 a 13
2 b 14
3 c 15
4 d 16
5 e 0
Elapsed: 00:00:00.11
SQL> select max(number_pole2) from int_table;
MAX(NUMBER_POLE2)
-----------------
16
Elapsed: 00:00:00.07
SQL> select min(number_pole2) from int_table;
MIN(NUMBER_POLE2)
-----------------
0
Elapsed: 00:00:00.07
SQL> select sum(number_pole2) from int_table;
SUM(NUMBER_POLE2)
-----------------
58
Elapsed: 00:00:00.06
SQL> select stddev(number_pole2) from int_table;
STDDEV(NUMBER_POLE2)
--------------------
6.58027355
Elapsed: 00:00:00.07
SQL> delete from int_table where mod(number_pole2, 2)=0;
3 rows deleted.
Elapsed: 00:00:00.06
SQL> select * from int_table;
NUMBER_POLE KEY_POLE NUMBER_POLE2
----------- ----------------------------------- ------------
1 a 13
3 c 15
Elapsed: 00:00:00.09
SQL> set timing off;
SQL> spool out;
Connected.
SQL> connect new_user/password
Connected.
SQL> set timing on;
SQL> create table int_table(
2 number_pole NUMBER(11) NOT NULL,
3 key_pole VARCHAR(35) NOT NULL,
4 primary key (key_pole));
Table created.
Elapsed: 00:00:00.16
SQL> GRANT INSERT, UPDATE, DELETE on int_table TO new_user;
Grant succeeded.
SQL> grant select on int_table to new_user;
Grant succeeded.
Elapsed: 00:00:00.03
SQL> insert into int_table values (1, 'a');
1 row created.
Elapsed: 00:00:00.05
SQL> insert into int_table values (2, 'b');
1 row created.
Elapsed: 00:00:00.04
SQL> insert into int_table values (3, 'c');
1 row created.
Elapsed: 00:00:00.04
SQL> insert into int_table values (4, 'd');
1 row created.
Elapsed: 00:00:00.05
SQL> insert into int_table values (5, 'e');
1 row created.
Elapsed: 00:00:00.04
SQL> alter table int_table add number_pole2 number(5, 0);
Table altered.
Elapsed: 00:00:00.11
SQL> update int_table
2 set number_pole2=mod(1+13+33, 17)
3 where number_pole=1;
1 row updated.
Elapsed: 00:00:00.07
SQL> update int_table
2 set number_pole2=mod(2+13+33, 17)
3 where number_pole=2;
1 row updated.
Elapsed: 00:00:00.04
SQL> update int_table
2 set number_pole2=mod(3+13+33, 17)
3 where number_pole=3;
1 row updated.
Elapsed: 00:00:00.04
SQL> update int_table
2 set number_pole2=mod(4+13+33, 17)
3 where number_pole=4;
1 row updated.
Elapsed: 00:00:00.05
SQL> update int_table
2 set number_pole2=mod(5+13+33, 17)
3 where number_pole=5;
1 row updated.
Elapsed: 00:00:00.05
SQL> select * from int_table
2 ;
NUMBER_POLE KEY_POLE NUMBER_POLE2
----------- ----------------------------------- ------------
1 a 13
2 b 14
3 c 15
4 d 16
5 e 0
Elapsed: 00:00:00.11
SQL> select max(number_pole2) from int_table;
MAX(NUMBER_POLE2)
-----------------
16
Elapsed: 00:00:00.07
SQL> select min(number_pole2) from int_table;
MIN(NUMBER_POLE2)
-----------------
0
Elapsed: 00:00:00.07
SQL> select sum(number_pole2) from int_table;
SUM(NUMBER_POLE2)
-----------------
58
Elapsed: 00:00:00.06
SQL> select stddev(number_pole2) from int_table;
STDDEV(NUMBER_POLE2)
--------------------
6.58027355
Elapsed: 00:00:00.07
SQL> delete from int_table where mod(number_pole2, 2)=0;
3 rows deleted.
Elapsed: 00:00:00.06
SQL> select * from int_table;
NUMBER_POLE KEY_POLE NUMBER_POLE2
----------- ----------------------------------- ------------
1 a 13
3 c 15
Elapsed: 00:00:00.09
SQL> set timing off;
SQL> spool out;
Соседние файлы в предмете Безопасность систем баз данных