{"id":16078,"date":"2020-05-18T22:43:58","date_gmt":"2020-05-18T22:43:58","guid":{"rendered":"https:\/\/ittutorial.org\/?p=16078"},"modified":"2020-05-20T23:31:33","modified_gmt":"2020-05-20T23:31:33","slug":"oracle-sql-tutorials-1-introduction-to-oracle-sql","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/oracle-sql-tutorials-1-introduction-to-oracle-sql\/","title":{"rendered":"Introduction to Oracle SQL | Oracle SQL Tutorials -1"},"content":{"rendered":"<p align=\"left\">Hi,<\/p>\n<p align=\"left\">I will explain Introduction to Oracle SQL in this post of Oracle SQL Tutorial series.<\/p>\n<p align=\"left\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-16079\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/05\/oracle-sql-tutorial.png\" alt=\"\" width=\"387\" height=\"311\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/05\/oracle-sql-tutorial.png 387w, https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/05\/oracle-sql-tutorial-300x241.png 300w\" sizes=\"auto, (max-width: 387px) 100vw, 387px\" \/><\/p>\n<p align=\"left\"><!--more--><\/p>\n<p align=\"left\">\n<p align=\"left\">\n<p align=\"left\">\n<p align=\"left\"><span style=\"color: #ff0000;\"><strong>If you don&#8217;t know what is the database and Why database, you can read the following posts before this.<\/strong><\/span><\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"fkLzs5TDeg\"><p><a href=\"https:\/\/ittutorial.org\/what-is-the-database-why-database\/\">What is the Database, Why Database ?<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;What is the Database, Why Database ?&#8221; &#8212; IT Tutorial\" src=\"https:\/\/ittutorial.org\/what-is-the-database-why-database\/embed\/#?secret=cG4o5dWXBv#?secret=fkLzs5TDeg\" data-secret=\"fkLzs5TDeg\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"atnyA5G6Ym\"><p><a href=\"https:\/\/ittutorial.org\/what-is-the-database-and-relational-database-management-system-rdbms\/\">What is the Database and Relational Database Management System (RDBMS)<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;What is the Database and Relational Database Management System (RDBMS)&#8221; &#8212; IT Tutorial\" src=\"https:\/\/ittutorial.org\/what-is-the-database-and-relational-database-management-system-rdbms\/embed\/#?secret=QcNhsewLGe#?secret=atnyA5G6Ym\" data-secret=\"atnyA5G6Ym\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p align=\"left\">\n<p align=\"left\"><span style=\"color: #ff0000;\"><strong><span lang=\"en-US\">WHAT IS SQL (STRUCTURED QUERY LANGUAGE) ?<\/span><\/strong><\/span><\/p>\n<p align=\"left\"><span lang=\"en-US\">SQL is not a programming language like C, JAVA, C ++ it <\/span><span lang=\"en-US\">is a sub language used in databases such as Oracle, MYSQL , SQL SERVER .<\/span><\/p>\n<p align=\"left\"><span lang=\"en-US\">SQL is a query language that is used to add , delete , access and update data in a database .<\/span><\/p>\n<p align=\"left\">\n<p align=\"left\">\n<p align=\"left\"><span style=\"color: #ff0000;\"><strong><span lang=\"en-US\">USAGE AREAS OF SQL<\/span><\/strong><\/span><\/p>\n<ul>\n<li>\n<p align=\"left\"><span lang=\"en-US\">Creating , modifying database objects ,<\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span lang=\"en-US\">Controlling access to database, objects ,<\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span lang=\"en-US\">Modeling , managing data sets ,<\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span lang=\"en-US\">Data query , add , delete operations are performed .<\/span><\/p>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p align=\"left\"><span style=\"color: #ff0000;\"><strong><span lang=\"en-US\">WHY CHOOSE SQL?<\/span><\/strong><\/span><\/p>\n<ul>\n<li>\n<p align=\"left\"><span lang=\"en-US\">Allows users to define and modify data .<\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span lang=\"en-US\">Allows users to set permissions on tables , views .<\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span lang=\"en-US\">Allows users to access data from relational database management systems .<\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span lang=\"en-US\">Allows modules to be embedded in different languages .<\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span lang=\"en-US\"><span class=\"tlid-translation translation\" lang=\"en\"><span class=\"\" title=\"\">Security, performance , data recovery features are the main features that are effective in choosing sql .<\/span><\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span lang=\"en-US\"><span class=\"tlid-translation translation\" lang=\"tr\"><span class=\"\" title=\"\">Provides quick processing of data and easy querying .<\/span><\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p align=\"left\"><span style=\"color: #ff0000;\"><strong><span lang=\"en-US\">CLASSIFICATION OF SQL COMMANDS<\/span><\/strong><\/span><\/p>\n<p align=\"left\"><span lang=\"en-US\">SQL commands are categorized into 3 sections according to their functions :<\/span><\/p>\n<ul>\n<li>\n<p align=\"left\"><span style=\"font-size: medium; color: #ff0000;\"><span lang=\"en-US\"><strong>DML (Data Manipulation Language) :<\/strong> <\/span><\/span><span style=\"font-size: medium;\"><span lang=\"en-US\">Data processing language .<\/span><\/span><span lang=\"en-US\"> For managing data with in table or schema objects <\/span><span style=\"font-size: medium;\"><span lang=\"en-US\">(SELECT , UPDATE , INSERT , MERGE , DELETE , CALL)<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span style=\"color: #ff0000;\"><strong><span style=\"font-size: medium;\"><span lang=\"en-US\">D<\/span><\/span><span style=\"font-size: medium;\"><span lang=\"en-US\">C<\/span><\/span><span style=\"font-size: medium;\"><span lang=\"en-US\">L (Data <\/span><\/span><span style=\"font-size: medium;\"><span lang=\"en-US\">Control<\/span><\/span><\/strong><\/span><span style=\"font-size: medium;\"><span lang=\"en-US\"><span style=\"color: #ff0000;\"><strong> Language) :<\/strong> <\/span>Data control language . Used to set authorization or privileges . <\/span><\/span><span style=\"font-size: large;\"><span lang=\"en-US\">(<\/span><\/span><span style=\"font-size: medium;\"><span lang=\"en-US\">GRANT,REVOKE)<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span style=\"color: #ff0000;\"><strong><span style=\"font-size: medium;\"><span lang=\"en-US\">D<\/span><\/span><span style=\"font-size: medium;\"><span lang=\"en-US\">D<\/span><\/span><span style=\"font-size: medium;\"><span lang=\"en-US\">L (Data <\/span><\/span><span style=\"font-size: medium;\"><span lang=\"en-US\">Definition<\/span><\/span><\/strong><\/span><span style=\"font-size: medium;\"><span lang=\"en-US\"><span style=\"color: #ff0000;\"><strong> Language) :<\/strong><\/span> Data definition language . Used to define tables, database structures, or schemas . <\/span><\/span><span style=\"font-size: medium;\"><span lang=\"en-US\">(CREATE , TRUNCATE , ALTER , COMMENT , DROP , RENAME)<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span style=\"font-size: medium;\"><span lang=\"en-US\"><span style=\"color: #ff0000;\"><strong>TCL (Transaction Control) :<\/strong> <\/span>The process is the control language . For managing changes made by DML . <\/span><\/span><span style=\"font-size: large;\"><span lang=\"en-US\">(<\/span><\/span><span style=\"font-size: medium;\"><span lang=\"en-US\">COMMIT , SAVEPOINT , ROLLBACK)<\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p align=\"left\"><span style=\"color: #ff0000;\"><strong><span style=\"font-size: large;\"><span style=\"font-size: medium;\"><span lang=\"en-US\">SQL WRITING RULES<\/span><\/span> <\/span><\/strong><\/span><\/p>\n<ul>\n<li>\n<p align=\"left\"><span style=\"font-size: medium;\">SQL statements do not distinguish between upper and lower case .<\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span style=\"font-size: medium;\"><span class=\"tlid-translation translation\" lang=\"en\"><span class=\"\" title=\"\">Keywords cannot be abbreviated or divided into lines<\/span><\/span> (keywords : Select , From , etc.) . <\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span style=\"font-size: medium;\">Expressions are usually in separate lines . <\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span style=\"font-size: medium;\">Typically , key expressions are written in capital letters . <\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span style=\"font-size: medium;\">Date and character type data is written to the left and numeric data is written adjacent to the right .<\/span><\/p>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p align=\"left\"><strong><span style=\"color: #ff0000;\">Most Important SQL Commands are as follows.<\/span><\/strong><\/p>\n<ul>\n<li>SELECT &#8211; query or extracts data from a database<\/li>\n<li>INSERT INTO &#8211; inserts data or records into a database<\/li>\n<li>UPDATE &#8211; updates and modify any data in a database<\/li>\n<li>DELETE &#8211; deletes any data from a database<\/li>\n<li>CREATE TABLE &#8211; creates a new table on Database<\/li>\n<li>ALTER TABLE &#8211; modifies any propery of table<\/li>\n<li>DROP TABLE &#8211; remove and purge a table<\/li>\n<li>CREATE INDEX &#8211; creates an index<\/li>\n<li>DROP INDEX &#8211; remove an index<\/li>\n<li>CREATE DATABASE &#8211; creates a new database on Instance<\/li>\n<li>ALTER DATABASE &#8211; change any propery of a database<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #ff0000;\">Do you want to learn Oracle Database for Beginners, then read the following articles.<\/span><\/h4>\n<blockquote class=\"wp-embedded-content\" data-secret=\"dzIiBtC6uf\"><p><a href=\"https:\/\/ittutorial.org\/oracle-tutorial-oracle-database-tutorials-for-beginners-junior-oracle-dba\/\">Oracle Tutorial | Oracle Database Tutorials for Beginners  ( Junior Oracle DBA )<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Oracle Tutorial | Oracle Database Tutorials for Beginners  ( Junior Oracle DBA )&#8221; &#8212; IT Tutorial\" src=\"https:\/\/ittutorial.org\/oracle-tutorial-oracle-database-tutorials-for-beginners-junior-oracle-dba\/embed\/#?secret=3bKDE6sug2#?secret=dzIiBtC6uf\" data-secret=\"dzIiBtC6uf\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, I will explain Introduction to Oracle SQL in this post of Oracle SQL Tutorial series.<\/p>\n","protected":false},"author":1,"featured_media":16079,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3019],"tags":[11350,5477,11353,9037,11347,11351,11348,11344,11352,11345,11349,3001,11302,3013,11346,2673,11301,3715],"class_list":["post-16078","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle-sql","tag-basic-of-oracle-sql","tag-how-to-learn-oracle-sql","tag-introduction-to-oracle-sql","tag-oracle-dba-tutorial","tag-oracle-introduction","tag-oracle-live-sql","tag-oracle-sql-certification","tag-oracle-sql-database","tag-oracle-sql-developer","tag-oracle-sql-download","tag-oracle-sql-online","tag-oracle-sql-tutorial","tag-oracle-sql-tutorial-pdf","tag-oracle-sql-tutorials","tag-oracle-sql-vs-mysql","tag-oracle-tutorial","tag-oracle-tutorial-pdf","tag-pl-sql-tutorial"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/05\/oracle-sql-tutorial.png","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16078","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=16078"}],"version-history":[{"count":1,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16078\/revisions"}],"predecessor-version":[{"id":16080,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16078\/revisions\/16080"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/16079"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=16078"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=16078"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=16078"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}