Syntaxe
insert into [nameSchema.] {nameTable | nameView | requestSelect}
[(nameColumn1, nameColumn2, ...)]
values (value1, value2, ...)
Exemples
Let us take the "employees" table consisted of the following columns:
id_Employee number
lastName_Employee varchar2(30)
firstName_Employee varchar2(30)
Inform all the columns
insert into employees
values (1, 'SMITH', 'John');
Inform certain columns
insert into employees
(id_Employee, lastName_Employee)
values (2, 'DOE');
Aucun commentaire:
Enregistrer un commentaire