Karteikarten
Oracle SQL
Karten in diesem Stapel (26)
- 1In Oracle, the SQL is organized into 5 categories. What are they?1. Query Statements, for accessing data
2. Data Manipulation Language (DML) for changing data
3. Data Definition Language (DDL) for modifying the structure of the database
4. Transaction Control (TC) Statements for recording changes to the data
5. Data Control Language (DCL) for changing database permissions - 2What is SQL?Structured Query Language
Standardized language for accessing and changing data - 3DMLData Manipulation Language
- 4Query StatementsSELECT - ALWAYS begin with "SELECT"
- Retrieve Data from the Database
- Data is typically retrieved in rows - 5Data Control Language (DCL)5. - Data Control Language (DCL)
GRANT - allows users to access portions were all of the database
REVOKE - removes permissions on the database previously granted to a users - 6Data Manipulation Language (DML)2. Data Manipulation Language (DML)
INSERT - Adds rows to a table/s
UPDATE - Changes rows within a table/s
DELETE - Removes rows within a table/s - 7Data Definition Language (DDL)3. Data Definition Language (DDL)
CREATE - Creates a structure within a database such as a table or a trigger
ALTER - alters the database structure
DROP - Drops a database structure
RENAME - Renames a table
TRUNCATE - Deletes all the rows from the table - 8Transaction Control (TC)4. Transaction Control (TC)
COMMIT - Save changes to data (additions, deletions or modifications)
ROLLBACK - Undoes changes made to the database
SAVE POINT - sets the point which you can rollback - 9DML - DATA MANIPULATION LANGUAGE: examplesINSERT, DELETE, UPDATE
- 10INSERTadds rows to a table or tables
- 11UPDATEchanges rows within a table or tables
- 12DELETEremoves rows within a tbale or tables
- 13DDL - Data Definition Language: examplesCREATE, ALTER, DROP, RENAME, TRUNCATE
- 14CREATEcreates a structure within a database such as a table or a trigger
- 15ALTERalters the database structure
- 16DROPdrops a database structure (or deletes it)
- 17RENAMERenames Table
- 18TRUNCATEdeletes all the rows from a table
- 19TRANSACTION CONTROLCOMMIT, ROLLBACK, SAVE POINT
- 20COMMITsave changes to data (additions, deletions, or modifications)
- 21ROLLBACKundoes changes made to the database.
- 22SAVE POINTsets the point in which you can rollback.
- 23DCLDATA CONTROL LANGUAGE
- 24DCL examples (2)GRANT, REVOKE
- 25GRANTGrants user authorization and permissions.
- 26REVOKEremoves permissions on the database previously granted.
Informationen
- Beschreibung
- Oracle SQL Karteikarten am Oracle SQL, erstellt von Amber Saxon am 20/11/2019.
- Erstellt von
- Amber Saxon
- Aufrufe
- 0
- Bewertung