Jumat, 28 Oktober 2011

Makul PBD II

Second Note

Syntag untuk manipulasi data :

-          Insert
-          Update
-          Delete
-          Merge

Example for syntag manipulating data insert :
Begin
Insert into employees
( employee_id, first_name, last_name, email, hire_date, job_id, salary)
Values
( employees_seq.Nextval, ‘ Ruth’, ‘Cors’, ‘ Rcores’, sysdate ‘ Ad_ASST’, 5000)
End;
/

Tidak ada komentar:

Posting Komentar