----------------------------------------- -------- ----------------------------
FIRST_NAME CHAR(15)
LAST_NAME CHAR(20)
SQL>
SQL> -- ÂÑÒÀÂÊÀ ÄÀÍÍÛÕ
SQL> INSERT INTO test_1 VALUES ('Jane', 'Smith');
1 row created.
SQL> INSERT INTO test_1 VALUES ('Christopher', 'Allen');
1 row created.
SQL>
SQL> -- ÂÛÁÎÐÊÀ ÄÀÍÍÛÕ
SQL> SELECT * FROM test_1;
FIRST_NAME LAST_NAME
--------------- --------------------
Jane Smith
Christopher Allen
SQL>
SQL> -- ÓÄÀËÅÍÈÅ ÒÀÁËÈÖÛ
SQL> DROP TABLE test_1;
Table dropped.
SQL>
SQL> -- ÏÐÎÂÅÐÊÀ ×ÒÎ ÒÀÁËÈÖÀ ÓÄÀËÅÍÀ
SQL> SELECT * FROM test_1;
SELECT * FROM test_1
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> --
SQL> -- ÑÎÇÄÀÍÈÅ ÒÀÁËÈÖÛ Ñ ÄÀÍÍÛÌÈ ÐÀÇËÈ×ÍÛÕ ÒÈÏÎÂ
SQL> --
SQL>
SQL> -- ÑÎÇÄÀÍÈÅ ÒÀÁËÈÖÛ
SQL> CREATE TABLE test_2 (
2 string_value VARCHAR2(20),
3 number_value NUMBER(6,2),
4 symbol_value CHAR(1),
5 date_value DATE );
Table created.
SQL>
SQL> -- ÂÑÒÀÂÊÀ ÄÀÍÍÛÕ
SQL> INSERT INTO test_2 VALUES ('AbcdeF', 1234.56, 'Z', '2001-01-04');
1 row created.
SQL> INSERT INTO test_2 VALUES ('Slovo1 Slovo2', 6543.21, 'A', '2004-12-23');
1 row created.
SQL> -- ÂÛÁÎÐÊÀ ÄÀÍÍÛÕ
SQL> SELECT * FROM test_2;
STRING_VALUE NUMBER_VALUE S DATE_VALUE
-------------------- ------------ - ----------
AbcdeF 1234.56 Z 2001-01-04
Slovo1 Slovo2 6543.21 A 2004-12-23
SQL> -- ÓÄÀËÅÍÈÅ ÂÑÅÕ ÑÒÐÎÊ
SQL> DELETE FROM test_2;
2 rows deleted.
SQL>
SQL> -- ÂÛÁÎÐÊÀ ÄÀÍÍÛÕ
SQL> SELECT * FROM test_2;
no rows selected
SQL>
SQL> -- ÓÄÀËÅÍÈÅ ÒÀÁËÈÖÛ
SQL> DROP TABLE test_2;
Table dropped.
SQL>
SQL> --
SQL> -- ÐÀÁÎÒÀ Ñ NULL-ÇÍÀ×ÅÍÈßÌÈ
SQL> --
SQL>
SQL> -- ÑÎÇÄÀÍÈÅ ÒÀÁËÈÖÛ
SQL> CREATE TABLE test_3 (
2 string_value VARCHAR2(20) NOT NULL,
3 number_value NUMBER(6,2) );
Table created.
SQL>
SQL> -- ÎÏÈÑÀÍÈÅ ÒÀÁËÈÖÛ
SQL> DESCRIBE test_3;