10g Oracle??????? ????? ((First level????? ?????? ((Database : By: Rima Aleryani 10g Oracle??????? ????? ((First level????? ?????? ((Database
????? ???????? ?????????Relational Database : ????? ???????? ?????????Relational Database ????? ???????? ????????? ?? ?????? ?? ??????? ???? ??? ????? ?? ??????.
????? ???????? ?? ????? ????? ?????? ??????? ???? ????? ????? ?? ???? ? ?????.
?? ???? ( (Column?? ??????? ?? ????? ?? ??? (Field)
?? ?? ( (Row????? ?? (Record)
??? ??? ??? ??????? ?? ????? ?????? ???? ((Relations
???? : ???? Students Table City Table
??? ??????????? SQL : ??? ??????????? SQL SQL)) Structured Query Language
????? ??? ??????? ???????
Data Retrieval
????? ???:
??? ??????? ???? ?? ???? select
Slide 5 : Data Manipulation Language (DML)
????? ??? ???????
????? ???? ?? ???? Insert
????? ???? ?? ???? Update
??? ?????? ???? ?? ???? Delete
Slide 6 : Data Definition Language (DDL)
????? ??? ???????:
????? ???? ?? ???? Create
????? ???? ?? ???? Alter
????? ???? ?? ???? Drop
????? ??? ???? ?? ???? Rename
??? ??? ?? ???? ?? ???? Truncate
Slide 7 : Transaction Control
????? ????? ???????? ?? ?????? Commit
?????? ?? ????? ?????? Rollback
?????? ????? ????? Savepoint
Slide 8 : Data Control Language
????? ????????? ?????????? ?????? ??? ???????? Grant
??? ????????? ?? ?????????? Revoke