{"id":11898,"date":"2019-11-08T20:00:44","date_gmt":"2019-11-08T20:00:44","guid":{"rendered":"https:\/\/ittutorial.org\/?p=11898"},"modified":"2019-11-20T20:03:45","modified_gmt":"2019-11-20T20:03:45","slug":"creating-other-schema-objects","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/creating-other-schema-objects\/","title":{"rendered":"Oracle SQL Tutorial -7 Creating Other Schema Objects"},"content":{"rendered":"<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: medium\">Hi ,<\/span><\/span><\/p>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: medium\"><span lang=\"en-US\">In this article I will tell you what is view , how to create\u00a0.\u00a0View is the collection of data from multiple tables into a single table and the ability to query by making restrictions from this table .<\/span> <\/span><\/span><\/p>\n<p align=\"left\"><span style=\"color: #0066b3\"><span style=\"font-size: large\">VIEW<\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">Creates an interface to extract data from one or more tables .<\/span> <\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<p align=\"left\"><span style=\"color: #ce181e\"><span style=\"font-size: large\"><span style=\"color: #0066b3\"><span lang=\"en-US\">VIEW TYPES<\/span><\/span><\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">Views are Simple and Complex .<\/span> <\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">Complex views include join , order by , group by .<\/span> <\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<p align=\"left\"><span style=\"color: #0066b3\"><span style=\"font-size: large\"><span lang=\"en-US\">CREATING VIEW<\/span><\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">CREATING VIEW<\/span> :<\/span><\/span><\/p>\n<\/li>\n<li>\n<pre><span style=\"color: #000000\"><span style=\"font-size: large\"><i>CREATE [OR REPLACE] [FORCE | NOFORCE] VIEW view [(alias [,alias]..)] AS SUBQUERY [WITH CHECK OPTION [CONSTRAINT constraint]] [WITH READ ONLY [CONSTRAINT constraint]];<\/i><\/span><\/span><\/pre>\n<\/li>\n<\/ul>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">Now let&#8217;s create our own view .<\/span> <\/span><\/span><\/p>\n<pre>CREATE VIEW test as select * from sh.customers;<\/pre>\n<p align=\"left\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-11900\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/2.7.png\" alt=\"\" width=\"246\" height=\"51\" \/><\/p>\n<p align=\"left\"><span style=\"color: #ce181e\"><span style=\"font-size: large\"><span style=\"color: #21409a\"><span lang=\"en-US\">VIEW FROM DATA<\/span><\/span><\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">Queries are drawn from the same table as a query .<\/span> <\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<pre><em>SELECT * FROM TEST;<\/em><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-11902\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/4.7-300x49.png\" alt=\"\" width=\"404\" height=\"66\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/4.7-300x49.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/4.7-768x126.png 768w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/4.7.png 962w\" sizes=\"auto, (max-width: 404px) 100vw, 404px\" \/><\/p>\n<p align=\"left\"><span style=\"color: #bd7cb5\"><span style=\"font-size: large\"><span style=\"color: #21409a\"><span lang=\"en-US\">CHANGING VIEW<\/span><\/span><\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">If there is a view that has already been created , let&#8217;s change it or make it :<\/span> <\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<pre><em>CREATE OR REPLACE VIEW test AS SELECT CUST_FIRST_NAME,CUST_LAST_NAME FROM SH.CUSTOMERS;<\/em><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-11904\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/6.7.png\" alt=\"\" width=\"256\" height=\"39\" \/><\/p>\n<p align=\"left\"><span style=\"color: #ce181e\"><span style=\"font-size: large\"><span style=\"color: #21409a\"><span lang=\"en-US\">VIEW ON DML<\/span><\/span><\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">We can do DML operations on simple view, but generally DML operations cannot be performed on complex view .<\/span> <\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">The WITH READ ONLY statement prevents view from being made on DML .<\/span> <\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">WITH CHECK OPTION allows DML to be controlled .<\/span> <\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">DMLs can be made in source tables on simple views .<\/span> <\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\">**<\/span><\/span><span lang=\"en-US\">To disable DML on a view , we create the view with READ ONLY .<\/span><\/p>\n<\/li>\n<\/ul>\n<p align=\"left\"><span style=\"color: #21409a\"><span style=\"font-size: large\">SEQUENCE<\/span><\/span><\/p>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">Because it is shareable , the public key can be used instead of the Primary key .<\/span> <\/span><\/span><\/p>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">Sequence can be accessed quickly via cache memory .<\/span> <\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\">CURRVAL : <\/span><\/span><span lang=\"en-US\">Displays the current value of Sequence .<\/span><\/p>\n<\/li>\n<\/ul>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">Use of :<\/span> <\/span><\/span><\/p>\n<pre><em>SELECT seq_ornek.CURRVAL FROM SH.CUSTOMERS;<\/em><\/pre>\n<ul>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\">NEXTVAL : <\/span><\/span><span lang=\"en-US\">It generates the next value and increases the counter , which is given to each user in the ordinary .<\/span><\/p>\n<\/li>\n<\/ul>\n<p lang=\"en-US\" align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\">Use of :<\/span><\/span><\/p>\n<pre><em>SELECT SEQ_ORNEK.NEXTVAL FROM SH.CUSTOMERS;<\/em><\/pre>\n<pre><em>CREATE SEQUENCE seq_ornek INCREMENT BY 1 START WITH 6 MAXVALUE 9999<\/em>\r\n\r\n<em>NOCACHE<\/em>\r\n\r\n<em>NOCYCLE;<\/em><\/pre>\n<p lang=\"en-US\" align=\"left\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-11908\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/10.7.png\" alt=\"\" width=\"323\" height=\"37\" \/><\/p>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">In the example above we have shown how to create a sequence .<\/span> <\/span><\/span><\/p>\n<p align=\"left\"><span style=\"color: #aa55a1\"><span style=\"font-size: large\"><span lang=\"en-US\">SEQUENCE CAVITIES<\/span><\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">ROLLBACK operations<\/span> ,<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">When the system crashes ,<\/span> <\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">Sequence when used elsewhere<\/span> <\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">And unnecessarily when the .NEXTVAL command is called<\/span> .<\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<p align=\"left\"><span style=\"color: #aa55a1\"><span style=\"font-size: large\"><span lang=\"en-US\">CHANGING THE SEQUENCE<\/span><\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\">Cycle ,<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\">Cache ,<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\">Increment by ,<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\">Maxvalue ,<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\">Minvalue <\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">When we want to change the Sequence , we can only change the above values .<\/span> <\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<pre><em>ALTER SEQUENCE SEQ_ORNEK INCREMENT BY 2 MAXVALUE 10000<\/em>\r\n\r\n<em>NOCACHE<\/em>\r\n\r\n<em>NOCYCLE;<\/em><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-11910\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/12.7.png\" alt=\"\" width=\"314\" height=\"35\" \/><\/p>\n<p align=\"left\"><span style=\"color: #21409a\"><span style=\"font-size: large\">INDEX<\/span><\/span><\/p>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">Objects used by Oracle to fetch a row faster .<\/span> <\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">Reduces disk input \/ output operations .<\/span> <\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">They are managed by Oracle .<\/span> <\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">A table can have more than one index .<\/span> <\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">They occupy a certain space on the disc .<\/span> <\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">They work with B Tree logic .<\/span> <\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<p align=\"left\"><span style=\"color: #21409a\"><span style=\"font-size: large\"><span style=\"color: #aa55a1\"><span lang=\"en-US\">CREATING INDEX<\/span><\/span><\/span><\/span><\/p>\n<p lang=\"en-US\" align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\">When we define primary key and Unique constraint , the index is created automatically . There may be one or more indexes on the table .<\/span><\/span><\/p>\n<pre><em>CREATE INDEX ADMIN.NEW_TABLE_IX ON ADMIN.NEW_TABLE(EMPLOYEE_ID);<\/em><\/pre>\n<p lang=\"en-US\" align=\"left\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-11912\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/14.7-300x30.png\" alt=\"\" width=\"390\" height=\"39\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/14.7-300x30.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/14.7.png 335w\" sizes=\"auto, (max-width: 390px) 100vw, 390px\" \/><\/p>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">In the example above , we have shown how to create our index .<\/span> <\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">Let&#8217;s look at the explain plan of our query , which lists the user whose name is melike:<\/span> <\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<pre><em>SELECT * FROM ADMIN.NEW_TABLE WHERE FIRST_NAME='melike';<\/em><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-11914\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/16.7-300x41.png\" alt=\"\" width=\"417\" height=\"57\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/16.7-300x41.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/16.7-768x105.png 768w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/16.7.png 866w\" sizes=\"auto, (max-width: 417px) 100vw, 417px\" \/><\/p>\n<ul>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">And now let&#8217;s index the same column and look at the explanation plan of the above query :<\/span> <\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<pre><em>CREATE INDEX ADMIN.NEW_TABLE_FIRSTNAME ON ADMIN.NEW_TABLE (FIRST_NAME);<\/em><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-11916\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/18.7-300x40.png\" alt=\"\" width=\"480\" height=\"64\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/18.7-300x40.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/18.7-768x102.png 768w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/18.7.png 877w\" sizes=\"auto, (max-width: 480px) 100vw, 480px\" \/><\/p>\n<p align=\"left\"><span style=\"color: #21409a\"><span style=\"font-size: large\"><span style=\"color: #aa55a1\"><span lang=\"en-US\">AFTER INDEX<\/span><\/span><\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">Let&#8217;s look at the explain plan of our query that we just run after creating an index :<\/span> <\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<pre><em>SELECT * FROM ADMIN.NEW_TABLE WHERE FIRST_NAME='melike';<\/em><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-11918\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/20.7-300x57.png\" alt=\"\" width=\"474\" height=\"90\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/20.7-300x57.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/20.7-768x146.png 768w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/20.7.png 877w\" sizes=\"auto, (max-width: 474px) 100vw, 474px\" \/><\/p>\n<p align=\"left\"><span style=\"color: #21409a\"><span style=\"font-size: large\"><span style=\"color: #aa55a1\"><span lang=\"en-US\">CREATE FUNCTION BASED INDEX<\/span><\/span><\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">In order to use these indexes , we must query them as they were created .<\/span> <\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<pre><em>CREATE INDEX ADMIN.NEW_TABLE_ISIM ON ADMIN.NEW_TABLE (UPPER(FIRST_NAME));<\/em><\/pre>\n<p>&nbsp;<\/p>\n<pre><em>SELECT * FROM ADMIN.NEW_TABLE WHERE UPPER(FIRST_NAME)='MELIKE' ;<\/em><\/pre>\n<p align=\"left\"><span style=\"color: #21409a\"><span style=\"font-size: large\">SYNONYM<\/span><\/span><\/p>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">They are aliases given to Synonym database objects , allowing the use of abbreviated names .<\/span><\/span><\/span> <span style=\"color: #000000\"><span lang=\"en-US\">In short , they are expressions that make it easier for other users to reach an object .<\/span><\/span> <span style=\"color: #000000\"><span style=\"font-size: large\"><span lang=\"en-US\">They can be seen by everyone (because they are created as public) .<\/span><\/span><\/span><\/p>\n<pre><span style=\"color: #000000\"><span style=\"font-size: large\"><i>CREATE [PUBLIC] SYNONYM synonym FOR object ;<\/i><\/span><\/span><\/pre>\n<ul>\n<li>\n<p align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><i><span lang=\"en-US\">For example , let&#8217;s rename the admin.new_table table :<\/span> <\/i><\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<pre><em>CREATE SYNONYM YENIKISI FOR ADMIN.NEW_TABLE;;<\/em><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-11922\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/24.7.png\" alt=\"\" width=\"284\" height=\"23\" \/><\/p>\n<p>&nbsp;<\/p>\n<pre><em>SELECT * FROM YENIKISI;<\/em><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-11924\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/26.7-300x19.png\" alt=\"\" width=\"521\" height=\"33\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/26.7-300x19.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/26.7-768x49.png 768w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/26.7.png 963w\" sizes=\"auto, (max-width: 521px) 100vw, 521px\" \/><\/p>\n<p align=\"left\"><span style=\"color: #21409a\"><span style=\"font-size: large\">DROP<\/span><\/span><\/p>\n<p align=\"left\"><span style=\"font-size: medium\"><span style=\"color: #000000\"><span lang=\"en-US\">With the drop command , many database objects are deleted from the database .<\/span><\/span> <span lang=\"en-US\">If we add the PURGE command to the table , they are deleted without being dumped in the trash .<\/span> <span style=\"color: #000000\"><span lang=\"en-US\">Below we wanted to delete the synonym we just created :<\/span><\/span> <\/span><\/p>\n<pre><em>DROP SYNONYM YENIKISI;<\/em><\/pre>\n<p align=\"left\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-11926\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/28.7.png\" alt=\"\" width=\"315\" height=\"37\" \/><\/p>\n<p lang=\"en-US\" align=\"left\"><span style=\"color: #000000\"><span style=\"font-size: large\"><b>See you in my next post.<\/b><\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi , In this article I will tell you what is view , how to create\u00a0.\u00a0View is the collection of data from multiple tables into a single table and the ability to query by making restrictions from this table . VIEW Creates an interface to extract data from one or more tables . VIEW TYPES &hellip;<\/p>\n","protected":false},"author":10447,"featured_media":12288,"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":[1340,6841,1572,6811,6836,6844,3000,4927,3002],"class_list":["post-11898","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle-sql","tag-oracle-sql","tag-oracle-sql-information","tag-sql","tag-sql-information","tag-sql-queries","tag-sql-sequence","tag-sql-tutorial","tag-sql-view","tag-what-is-sql"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/views.gif","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/11898","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\/10447"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=11898"}],"version-history":[{"count":8,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/11898\/revisions"}],"predecessor-version":[{"id":12403,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/11898\/revisions\/12403"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/12288"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=11898"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=11898"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=11898"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}