sql_lab1

SQL> connect system/password
Connected.
SQL> create table ulanov_table(
2 number_pole NUMBER(11) NOT NULL,
3 string_pole VARCHAR(35) NOT NULL,
4 number_pole2 NUMBER(11) NOT NULL,
5 string_pole2 NUMBER(35) NOT NULL,
6 key_pole VARCHAR(35) NOT NULL,
7 primary key (key_pole));

Table created.

SQL> create user ulanov_user identified by password
2 default tablespace users
3 temporary tablespace temp
4 quota 10m on users;

User created.

SQL> GRANT CONNECT, RESOURCE, CREATE VIEW TO ulanov_user;

Grant succeeded.

SQL> GRANT INSERT, UPDATE, DELETE on ulanov_table TO ulanov_user;

Grant succeeded.

SQL> grant select on system.ulanov_table to ulanov_user;

Grant succeeded.

SQL> connect ulanov_user/password
Connected.

SQL> insert into system.ulanov_table values(1,'a',2,5,'asd');

1 row created.

SQL> insert into system.ulanov_table values(1,'a',2,5,'sdfjang;ladkf');

1 row created.

SQL> select * from system.ulanov_table;

NUMBER_POLE STRING_POLE NUMBER_POLE2 STRING_POLE2
----------- ----------------------------------- ------------ ------------
KEY_POLE
-----------------------------------
1 a 2 3
f

1 a 2 5
g

1 a 2 5
a


NUMBER_POLE STRING_POLE NUMBER_POLE2 STRING_POLE2
----------- ----------------------------------- ------------ ------------
KEY_POLE
-----------------------------------
1 a 2 5
asd

1 a 2 5
sdfjang;ladkf


SQL> select * from system.xyu;

NUMBER_POLE STRING_POLE NUMBER_POLE2 STRING_POLE2
----------- ----------------------------------- ------------ ------------
KEY_POLE
-----------------------------------
1 a 2 3
f

1 a 2 5
g

1 a 2 5
a


NUMBER_POLE STRING_POLE NUMBER_POLE2 STRING_POLE2
----------- ----------------------------------- ------------ ------------
KEY_POLE
-----------------------------------
1 a 2 5
asd

1 a 2 5
sdfjang;ladkf


SQL> spool out


select chislo*4 from system.tablica;
поле числовое умноженное на номер в группе
select * from system.tablica order by stroka;
сортировка по текстовому полю
по убыванию

desc
дописать
select * from system.tablica where chislo=52;
выборка из таблицы по полю