dimanche 15 janvier 2012

SQL for Oracle : insert data

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