, DML. . DML - INSERT. INSERT, . , INSERT:
---------------- INSERT INTO --- ---------------------------------------------------
-------------------------------- ( ) -------------------------------------
--------------------------------------- , --------------------------------------------------
----------------------- VALUES --- (); --------------------------------------------
----------------------- --------------------------------------------
, , "" - , . " " - , . "" - . " " - SELECT, . VALUES. , , . . :
DROP TABLE PEOPLE
/
DROP TABLE NEWPEOPLE
/
COMMIT
/
PEOPLE :
CREATE TABLE PEOPLE
(
ID NUMBER PRIMARY KEY,
NM VARCHAR2(50),
FM VARCHAR2(50),
OT VARCHAR2(50)
)
/
COMMIT
/
:
SQL> CREATE TABLE PEOPLE
2 (
3 ID NUMBER PRIMARY KEY,
4 NM VARCHAR2(50),
5 FM VARCHAR2(50),
6 OT VARCHAR2(50)
7 )
8 /
.
SQL> COMMIT
2 /
.
ID PEOPLE! PRIMARY KEY, . . NULL! , INSERT, :
INSERT INTO PEOPLE(ID, NM, FM, OT)
VALUES(1, 'John', 'Godwin', 'Petrovich')
/
INSERT INTO PEOPLE(ID, NM, FM, OT)
VALUES(2, 'Bob', 'Doris', 'Martovich')
/
INSERT INTO PEOPLE(ID, NM, FM, OT)
VALUES(3, 'Frank', 'Black', 'Milleniumich')
/
INSERT INTO PEOPLE(ID, NM, FM, OT)
VALUES(4, 'Pupkin', 'Misha', 'Semenovich')
/
INSERT INTO PEOPLE(ID, NM, FM, OT)
VALUES(5, 'Pistoletov', 'Makar', 'Patronovich')
/
INSERT INTO PEOPLE(ID, NM, FM, OT)
VALUES(6, 'Avtomatov', 'Kolya', 'Pricelovich')
/
COMMIT
/
:
SQL> INSERT INTO PEOPLE(ID, NM, FM, OT)
2 VALUES(1, 'John', 'Godwin', 'Petrovich')
3 /
1 .
SQL> INSERT INTO PEOPLE(ID, NM, FM, OT)
2 VALUES(2, 'Bob', 'Doris', 'Martovich')
3 /
1 .
SQL> INSERT INTO PEOPLE(ID, NM, FM, OT)
2 VALUES(3, 'Frank', 'Black', 'Milleniumich')
3 /
1 .
SQL> INSERT INTO PEOPLE(ID, NM, FM, OT)
2 VALUES(4, 'Pupkin', 'Misha', 'Semenovich')
3 /
1 .
SQL> INSERT INTO PEOPLE(ID, NM, FM, OT)
2 VALUES(5, 'Pistoletov', 'Makar', 'Patronovich')
3 /
1 .
SQL> INSERT INTO PEOPLE(ID, NM, FM, OT)
2 VALUES(6, 'Avtomatov', 'Kolya', 'Pricelovich')
3 /
1 .
SQL> COMMIT
2 /
.
INTO PEOPLE(ID, NM, FM, OT) INSERT , . VALUES(6, 'Avtomatov', 'Kolya', 'Pricelovich') INSERT . INSERT.
, . PEOPLE . , , , . INSERT SELECT. :
CREATE TABLE OLD_PEOPLE
(
ID NUMBER PRIMARY KEY,
NM VARCHAR2(50),
FM VARCHAR2(50),
OT VARCHAR2(50)
)
/
COMMIT
/
: SQL> CREATE TABLE OLD_PEOPLE 2 ( 3 ID NUMBER PRIMARY KEY, 4 NM VARCHAR2(50), 5 FM VARCHAR2(50), 6 OT VARCHAR2(50) 7 ) 8 / . SQL> COMMIT 2 / .
INSERT , :
INSERT INTO OLD_PEOPLE
SELECT * FROM PEOPLE
/
:
SQL> INSERT INTO OLD_PEOPLE
2 SELECT * FROM PEOPLE
3 /
6 .
SQL> COMMIT
2 /
.
. , SELECT , . , !!! , . . , , DML - INSERT. PEOPLE OLD_PEOPLE, . , .
