SQL: Structured Query Language.
It is a common language used by any RDBMS to do basic operations on their RDBMS. Following are the features of SQL: -
1. It is simple English like language and uses commands such as Select, Create, Drop etc., in its commands.
2. It is not having If, Loop, Variables and most of the commands are Single line commands.
3. To implement application Logics, SQL has got extension Language popularly called as PL/SQL (Procedural Language of SQL).
4. The entire SQL has been divided into 4 major categories. They are-
• Data Manipulation Language (SELECT, INSERT, UPDATE, DELETE)
• Data Definition Language (CREATE, ALTER, DROP, TRUNCATE)
• Transaction Control Language (COMMIT, ROLLBACK)
• Data Control Language (GRANT, REOVE)
COMMIT=SAVE; ROLLBACK=UNDO
#SQL #DML #DDL #TCL #DCL #RDBMS #Exadata #RAC #ASM #Oracle
Please do follow me and support me on,
LinkedIn: https://www.linkedin.com/in/mallik034
YouTube: https://www.youtube.com/c/mallik034
Fakebook: https://www.facebook.com/mallik034
Blog: https://mallik034.blogspot.com
twitter: https://twitter.com/mallik034
Instagram: https://www.instagram.com/mallik034
FBPage: https://www.facebook.com/mallik034oracledba
Skype: malluramadurg
Regards,
Mallikarjun Ramadurg
Mobile: +91 9880616848
WhatsApp: +91 9880616848
Email: [email protected]
LinkedIn: https://www.linkedin.com/in/mallik034
YouTube: https://www.youtube.com/c/mallik034
Fakebook: https://www.facebook.com/mallik034
Blog: https://mallik034.blogspot.com
twitter: https://twitter.com/mallik034
Instagram: https://www.instagram.com/mallik034
FBPage: https://www.facebook.com/mallik034oracledba
Skype: malluramadurg