What are the types of SQL Statement?
Answers were Sorted based on User's Feedback
Answer / swapnareddy
Type of sql statments are:
DDL:Data Defintion Language:create,alter,drop,truncate & rename
DML:Data Manipulation Language:insert,update,delete & merge
DRL/DQL:Data retrive/query Language:select
DCL:Data Contol Language:grant,revoke
DTL:Data Transition Language:commit,savepoint & rollback
Is This Answer Correct ? | 55 Yes | 9 No |
SQL statements are classified into 6 categories:
1. Data Definition Language (DDL) Statements are:
- ALTER
- ANALYZE
- ASSOCIATE STATISTICS
- AUDIT
- COMMENT
- CREATE
- DISASSOCIATE STATISTICS
- DROP
- FLASHBACK
- GRANT
- NOAUDIT
- PURGE
- RENAME
- REVOKE
- TRUNCATE
- UNDROP
2. Data Manipulation Language (DML) statements are:
- CALL
- DELETE
- EXPLAIN PLAN
- INSERT
- LOCK TABLE
- MERGE
- SELECT
- UPDATE
3. Transaction Control Language (TCL) statements are:
- COMMIT
- ROLLBACK
- SAVEPOINT
- SET TRANSACTION
4. Session Control Language (SSCL) statements are:
- ALTER SESSION
- SET ROLE
5. System Control Language (SCL) Statements are:
- ALTER SYSTEM
6. EMBEDED SQL STATEMENTS
Is This Answer Correct ? | 26 Yes | 9 No |
Answer / anil_abbireddy
DDL :data definition language
DML :data manuplation language
DCL :data control language
TCL :transaction control language
SCL :session control language
Is This Answer Correct ? | 22 Yes | 15 No |
diff b/w function and procedure?
Explain the difference in execution of triggers and stored procedures?
What is data definition language?
What are the subsets of sql?
Its possible to add more than one primary key for the table
Explain what is a view?
How do you respond to dementia behavior?
what is the difference between char and varchar data types? : Sql dba
What is the best partition size for windows 10?
What trigger means?
What is memory optimized?
How do I view tables in sql developer?