Database Languages
Applications interact with the database thru a special language called SQL(STRUCTURED QUEY LANGUAGE)
DDL(Create, Alter, Drop)
DML(Insert, Update, Delete)
DQL(Select)
TCL(Commit, Rollback, Savepoint)
DCL(Grant, Revoke)
INTERFACES
Following are two important types of Database Interface :
Interactive : SQL can be used interactively from a terminal with tools like SQL Plus
Embedded : SQL can be embedded in another host language program which interacts with the database.
We also have User-Interface, which are typically Graphical User Interfaces(GUIs) which make interaction with the Database much easier(Example :Toad, PLSQL Developer, etc)
No comments:
Post a Comment