{"id":9923,"date":"2019-06-22T14:17:07","date_gmt":"2019-06-22T14:17:07","guid":{"rendered":"https:\/\/ittutorial.org\/?p=9923"},"modified":"2019-07-24T08:37:56","modified_gmt":"2019-07-24T08:37:56","slug":"sql-tutorial-sql-statements-select","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/sql-tutorial-sql-statements-select\/","title":{"rendered":"ORACLE SQL Dersleri- SQL STATEMENTS (SELECT)"},"content":{"rendered":"

Merhaba SQL Yaz\u0131lar\u0131na devam ediyoruz, bu yaz\u0131da veritaban\u0131m\u0131zdaki tablolar\u0131 sorgulama ifadesine bakaca\u011f\u0131z. Bu yaz\u0131ya ge\u00e7meden \u00f6nce bir \u00f6nceki yaz\u0131m\u0131z\u0131 okuman\u0131z\u0131 tavsiye ederim<\/p>\n

https:\/\/ittutorial.org\/sql-tutorial-int\u2026tion-to-database\/<\/a><\/p>\n

 <\/p>\n

Basic SQL Commands :<\/h1>\n

SQL yaz\u0131m\u0131nda SHOW <\/strong>kullan\u0131m\u0131 veritaban\u0131nda ve tablolarda bulunan bilgileri g\u00f6r\u00fcnt\u00fcler.<\/p>\n

SHOW DATABASES;<\/span><\/span><\/span><\/pre>\n
SHOW TABLES;<\/pre>\n
\"\"
\nSHOW TABLES<\/strong> komutunu kullanmadan \u00f6nce bir veritaban\u0131n\u0131 se\u00e7memiz gerekiyor, b\u00f6ylelikle se\u00e7ti\u011fimiz veritaban\u0131ndaki b\u00fct\u00fcn tablolar\u0131 listeleyebiliyoruz.<\/p>\n
SHOW COLUMNS <\/strong>komutuyla tablonuzdaki kolonlar\u0131 ve \u00f6zelliklerini g\u00f6r\u00fcnteleyebiliyorsunuz<\/p>\n
 <\/p>\n
Field<\/b>: Kolon ismi
\nType<\/b>: Kolona girilen verinin tipi
\nKey<\/b>: Kolonun index’li olup olmad\u0131\u011f\u0131n\u0131 g\u00f6sterir
\nDefault<\/b>: Kolona gelicek Default de\u011feri g\u00f6sterir
\nExtra<\/b>: Belirli s\u00fctun i\u00e7in ek bilgi i\u00e7erir.<\/h6>\n
 <\/p>\n
SELECT Statement :<\/h1>\n
 <\/p>\n
SELECT<\/strong> ifadesi veritaban\u0131ndan veri almak <\/strong>i\u00e7in kullan\u0131l\u0131r.<\/p>\n
Bir sorgu, se\u00e7ilen s\u00fctunlar\u0131 veya tablonun t\u00fcm sutunlar\u0131 i\u00e7in listeleme yapabilir.<\/p>\n
SELECT ifadesi i\u00e7in yaz\u0131m kural\u0131 ;<\/p>\n
 <\/p>\n
SELECT kolon_ismi<\/strong> FROM tablo_ismi\r\n\r\n<\/strong><\/pre>\n
E\u011fer t\u00fcm kolonlar\u0131 listelemek istersek kolon_ismi<\/strong> yerine * <\/strong>koymak yeterli olacakt\u0131r<\/p>\n
SELECT User, Password FROM user;<\/pre>\n
\"\"<\/p>\n
Bir sonraki yaz\u0131da g\u00f6r\u00fc\u015fmek \u00fczere..<\/p>\n
<\/pre>\n","protected":false},"excerpt":{"rendered":"
Merhaba SQL Yaz\u0131lar\u0131na devam ediyoruz, bu yaz\u0131da veritaban\u0131m\u0131zdaki tablolar\u0131 sorgulama ifadesine bakaca\u011f\u0131z. Bu yaz\u0131ya ge\u00e7meden \u00f6nce bir \u00f6nceki yaz\u0131m\u0131z\u0131 okuman\u0131z\u0131 tavsiye ederim https:\/\/ittutorial.org\/sql-tutorial-int\u2026tion-to-database\/   Basic SQL Commands : SQL yaz\u0131m\u0131nda SHOW kullan\u0131m\u0131 veritaban\u0131nda ve tablolarda bulunan bilgileri g\u00f6r\u00fcnt\u00fcler. SHOW DATABASES; SHOW TABLES; SHOW TABLES komutunu kullanmadan \u00f6nce bir veritaban\u0131n\u0131 se\u00e7memiz gerekiyor, b\u00f6ylelikle se\u00e7ti\u011fimiz veritaban\u0131ndaki b\u00fct\u00fcn …<\/p>\n","protected":false},"author":67,"featured_media":9920,"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":[5487],"tags":[4929,4875,4883,4873,4869,4910,1340,4870,4895,4905,4935,4926,4915,4921,4919,4920,4918,4917,3192,4872,4916,4928,4876,4912,4881,4880,4890,4867,3062,4879,4891,4923,4924,4922,4925,4909,4911,4877,4896,4908,4882,4884,4897,4901,4900,4898,4902,4903,4899,4871,3015,3018,4868,4904,4906,4893,4930,4934,4914,4933,4885,4887,4913,3000,4931,4889,4927,4907,4888,4886,4892,4874,4878,4894,4932],"class_list":["post-9923","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle-sql-turkce","tag-create-view","tag-database-nedir","tag-insert-nedir","tag-kolay-sql","tag-mysql-sql","tag-or","tag-oracle-sql","tag-php-sql","tag-plsql","tag-right-outer-join","tag-selecting-multiple-colum","tag-sql-all-drop","tag-sql-all-statements","tag-sql-alter","tag-sql-alter-colum","tag-sql-alter-database","tag-sql-alter-statement","tag-sql-alter-table","tag-sql-and","tag-sql-baslangic-dersleri","tag-sql-creat-table","tag-sql-create-view","tag-sql-database","tag-sql-date-functions","tag-sql-dcl","tag-sql-ddl","tag-sql-delete","tag-sql-dersleri","tag-sql-distinct","tag-sql-dml","tag-sql-dml-nedir","tag-sql-drop-colum","tag-sql-drop-database","tag-sql-drop-statement","tag-sql-drop-table","tag-sql-filtering-data","tag-sql-functions","tag-sql-ifadeleri","tag-sql-ile-ne-yapilir","tag-sql-in-statement","tag-sql-insert","tag-sql-insert-nasil-yapilir","tag-sql-is-ilanlari","tag-sql-join-yapisi","tag-sql-kaynaklari","tag-sql-kullanmak","tag-sql-lef-join","tag-sql-left-outer-join","tag-sql-makaleleri","tag-sql-nasil-ogrenilir","tag-sql-nedir","tag-sql-ogrenme","tag-sql-ogrenmek","tag-sql-right-join","tag-sql-right-outer-join","tag-sql-select-islemi","tag-sql-set-auto-increment","tag-sql-sorting-results","tag-sql-subqueries","tag-sql-syntaxt-rule","tag-sql-tablo-olusturma","tag-sql-tablo-yapisi","tag-sql-to_char-function","tag-sql-tutorial","tag-sql-union-statement","tag-sql-update-islemi","tag-sql-view","tag-sql-where-statement","tag-sql-yapisi","tag-tablo-nedr","tag-tablodan-veri-cekmek","tag-temel-seviye-sql","tag-temel-seviyede-sql","tag-tsql","tag-union-table"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/06\/sql-express.png","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/9923","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\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=9923"}],"version-history":[{"count":9,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/9923\/revisions"}],"predecessor-version":[{"id":9982,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/9923\/revisions\/9982"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/9920"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=9923"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=9923"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=9923"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}