----------------------------------------- -------- ----------------------------
STRING_VALUE NOT NULL VARCHAR2(20)
NUMBER_VALUE NUMBER(6,2)
SQL>
SQL> -- ÂÑÒÀÂÊÀ ÄÀÍÍÛÕ
SQL> INSERT INTO test_3 VALUES ('Text1', 100);
1 row created.
SQL> INSERT INTO test_3 VALUES ('Text2', NULL);
1 row created.
SQL>
SQL> -- ÂÛÁÎÐÊÀ ÄÀÍÍÛÕ
SQL> SELECT * FROM test_3;
STRING_VALUE NUMBER_VALUE
-------------------- ------------
Text1 100
Text2
SQL>
SQL> -- ÂÑÒÀÂÊÀ ÍÅÂÅÐÍÛÕ ÄÀÍÍÛÕ
SQL> INSERT INTO test_3 VALUES (NULL, 200);
INSERT INTO test_3 VALUES (NULL, 200)
*
ERROR at line 1:
ORA-01400: cannot insert NULL into ("SYSTEM"."TEST_3"."STRING_VALUE")
SQL>
SQL> -- ÂÛÁÎÐÊÀ ÄÀÍÍÛÕ
SQL> SELECT * FROM test_3;
STRING_VALUE NUMBER_VALUE
-------------------- ------------
Text1 100
Text2
SQL>
SQL> -- ÓÄÀËÅÍÈÅ ÒÀÁËÈÖÛ
SQL> DROP TABLE test_3;
Table dropped.
SQL>
SQL>
SQL> --
SQL> -- ÂÛÁÎÐÊÀ È ÂÑÒÀÂÊÀ ÄÀÍÍÛÕ Ñ ßÂÍÛÌ ÓÊÀÇÀÍÈÅÌ ÑÒÎËÁÖÀ
SQL> --
SQL>
SQL> -- ÑÎÇÄÀÍÈÅ ÒÀÁËÈÖÛ
SQL> CREATE TABLE test_4 (
2 string_value VARCHAR2(20),
3 number_value NUMBER(6,2) );
Table created.
SQL>
SQL> -- ÂÑÒÀÂÊÀ ÄÀÍÍÛÕ
SQL> INSERT INTO test_4 VALUES ('Word1', 1000);
1 row created.
SQL> INSERT INTO test_4 VALUES ('Word2', 2000);
1 row created.
SQL>
SQL> -- ÂÑÒÀÂÊÀ ÄÀÍÍÛÕ Ñ ÓÊÀÇÀÍÈÅÌ ÑÒÎËÁÖÎÂ
SQL> INSERT INTO test_4 (string_value, number_value) VALUES ('Word3', 3000);
1 row created.
SQL> INSERT INTO test_4 (number_value, string_value) VALUES (4000, 'Word4');
1 row created.
SQL> INSERT INTO test_4 (number_value) VALUES (5000);
1 row created.
SQL> INSERT INTO test_4 (string_value) VALUES ('Word6');
1 row created.
SQL>
SQL> -- ÂÛÁÎÐÊÀ ÄÀÍÍÛÕ
SQL> SELECT * FROM test_4;
STRING_VALUE NUMBER_VALUE
-------------------- ------------
Word1 1000
Word2 2000
Word3 3000
Word4 4000
Word6
6 rows selected.
SQL>
SQL> -- ÂÛÁÎÐÊÀ ×ÀÑÒÈ ÑÒÎËÁÖΠÄÀÍÍÛÕ
SQL> SELECT string_value, number_value FROM test_4;
STRING_VALUE NUMBER_VALUE
-------------------- ------------
Word1 1000
Word2 2000
Word3 3000
Word4 4000
Word6
6 rows selected.
SQL> SELECT number_value, string_value FROM test_4;
NUMBER_VALUE STRING_VALUE
------------ --------------------
1000 Word1
2000 Word2
3000 Word3
4000 Word4
Word6
6 rows selected.
SQL> SELECT number_value FROM test_4;
NUMBER_VALUE
------------
6 rows selected.
SQL> SELECT string_value FROM test_4;
STRING_VALUE
--------------------
Word1
Word2
Word3
Word4
Word6
6 rows selected.
SQL>
SQL> -- ÓÄÀËÅÍÈÅ ÒÀÁËÈÖÛ
SQL> DROP TABLE test_4;
Table dropped.
SQL>
SQL> --
SQL> -- ÏÐÎÑÒÛÅ ÌÀÒÅÌÀÒÈ×ÅÑÊÈÅ ÎÏÅÐÀÖÈÈ ÏÐÈ ÂÛÁÎÐÊÅ ÄÀÍÍÛÕ
SQL> --
SQL>
SQL> -- ÑÎÇÄÀÍÈÅ ÒÀÁËÈÖÛ
SQL> CREATE TABLE test_5 (
2 number_1 INTEGER,
3 number_2 FLOAT );
Table created.
SQL>
SQL> -- ÂÑÒÀÂÊÀ ÄÀÍÍÛÕ
SQL> INSERT INTO test_5 VALUES (100, 0.100);
1 row created.
SQL> INSERT INTO test_5 VALUES (200, 0.200);
1 row created.
SQL> INSERT INTO test_5 VALUES (300, 0.300);
1 row created.
SQL>
SQL> -- ÂÛÁÎÐÊÀ ÄÀÍÍÛÕ
SQL> SELECT number_1*2 FROM test_5;
NUMBER_1*2
----------
SQL> SELECT number_2*2 FROM test_5;
NUMBER_2*2
----------
.2
.4
.6
SQL> SELECT number_1+number_2 FROM test_5;
NUMBER_1+NUMBER_2
-----------------
100.1
200.2
300.3
SQL> SELECT SIN(number_2) FROM test_5;
SIN(NUMBER_2)
-------------
.099833417
.198669331
.295520207
SQL> SELECT EXP(number_2)*number_1 FROM test_5;
EXP(NUMBER_2)*NUMBER_1
----------------------
110.517092
244.280552
404.957642
SQL>
SQL> -- ÓÄÀËÅÍÈÅ ÒÀÁËÈÖÛ
SQL> DROP TABLE test_5;
Table dropped.
SQL>