Ndingawana sei ruzivo rwakabatana netafura iri muOracle Database Express Edition?

Mawaniro eruzivo ane chekuita ne ⁤tafura muOracle Database Express Edition?

Mumunda wekutonga uye manejimendi edhatabhesi, Oracle Database Chinyorwa cheExpress Isarudzo yakakurumbira pakati penyanzvi uye tekinoroji vanofarira. Iyi manejimendi system madhatabhesi hukama hunopa huwandu hwakawanda hwezvishandiso uye mashandiro anobvumira kuwana uye kunyengera kwedata zvinobudirira. Pakushanda ne Oracle Database Express Edition, zvakakosha kuve nekugona kuwana ruzivo rwune chekuita netafura chaiyo. Tevere, nzira dzakasiyana uye matekiniki acharatidzwa kuti asangane nechinangwa ichi.

SARUDZA mibvunzo

Imwe yedzakajairika uye nyore nzira dzekuwana ruzivo dzine chekuita netafura muOracle Database Express Edition iri kuburikidza nemibvunzo. SARUDZA. Ichi chirevo cheSQL chinokutendera kuti usarudze makoramu anodikanwa kubva patafura chaiyo, uchidzosa marekodhi anozadzisa mamwe mamiriro. Nekushandisa zvine musoro uye kuenzanisa vashandisi, zvinokwanisika kusefa iyo data uye kuwana chete ruzivo rwunodiwa. Mukuwedzera, mibvunzo SARUDZA Vanobvumirawo kuverenga uye kuunganidza kuti zviitwe, nokudaro zvichipa huwandu hukuru hwekuongorora patafura.

Data Dictionary metadata

Imwe mhinduro yekuwana ruzivo rwakabatana netafura muOracle Dhijitari yeExpress yeDatabase iri kuburikidza nemetadata yeduramazwi redata. Oracle inochengetedza seti yematafura uye maonero ane ruzivo rwakakura nezve chimiro uye zvirimo zve dhatabhesi. Iyi metadata inosanganisira zvinhu zvakaita sezita retafura, makoramu, zvinomanikidza, indexes, pakati pezvimwe. Nekubvunza matafura aya uye maonero eduramazwi redata, zvinokwanisika kuwana ruzivo rwakakwana uye rwakadzama nezveimwe tafura chaiyo.

ZVINOSHANDISWA uye maturusi ekutonga

Pamusoro pezvisarudzo zvataurwa pamusoro, Oracle Database Express Edition inopa zvakasiyana⁢ ZVINOSHANDISWA uye maturusi ekutonga anoita kuti zvive nyore kuwana ruzivo rwakabatana netafura. Izvi zvinoshandiswa zvinosanganisira kushandiswa kwezvishandiso zvemifananidzo zvakaita seOracle Mugadziri weSQL uye SQL*Plus, pamwe chete nemanyoro chaiwo nemirairo. Nezvishandiso izvi zvekutonga uye zvekushandisa, vashandisi vane kugona kuona, kuongorora, uye kutumira kunze data nemazvo, nekudaro vanogutsa zvavanoda ruzivo.

Muchidimbu, kuwana ruzivo rwakabatana netafura muOracle ⁢Database Express⁣ Edition Inzira zvakakosha pakutonga nekugadzirisa dhatabhesi. Nokushandisa mibvunzo SARUDZA, data duramazwi metadata, uye manejimendi ekushandisa aripo, vashandisi vane akawanda sarudzo dzekuwana uye kuongorora data nenzira kwayo uye inoshanda.

Tarira: Oracle Database Express Edition ndeyemahara, yakaganhurirwa Oracle Database sarudzo, yakagadzirirwa kusimudzira, prototyping, uye yekupinda-level application.

- Nhanganyaya⁤ yekuwana ruzivo muOracle Database Express Edition

Kuwana ruzivo muOracle Database Express Edition kwakakosha kune chero mushandisi kana mugadziri anoshanda neiyi manejimendi system. yemadhatabhesi. Musumo ino, tichaongorora nzira dzakasiyana dzekuwana chaiyo data kubva patafura muOracle Database Express Edition.

Imwe yedzakajairika nzira dzekuwana ruzivo dzine chekuita netafura ndeye Mibvunzo yeSQL. ⁤ Nekushandisa mutauro wemubvunzo wakarongeka, zvinokwanisika kuita mibvunzo yakasarudzika kune imwe tafura, kusefa data maererano nemamwe maitiro. MuOracle Database Express Edition, iyo SELECT clause inogona kushandiswa kutaura kuti ndeapi makoramu ekudzosa, pamwe neiyo WHERE clause yekusefa iyo data. Pamusoro pezvo, zvinogoneka kushandisa zvimwe zvikamu zvakaita seJOIN kubatanidza data kubva kumatafura akawanda.

Imwe nzira yekuwana ruzivo kubva patafura muOracle Database Express Edition ndeyekushandisa maturusi ekusimudzira akadai seSQL Developer. Ichi chishandiso chinopa graphical interface yekudyidzana nedatabase uye kuita mibvunzo. NeSQL Developer, zvinokwanisika kuongorora chimiro chetafura, kuona makoramu ayo uye zvipingaidzo, pamwe nekuita mibvunzo uye kuona mhedzisiro yacho intuitively. Iwe unogona zvakare kushandisa zvimwe zvepamberi zveSQL Developer, senge SQL debugger, kuongorora nekugadzirisa mibvunzo.

Kuwedzera kune SQL mibvunzo uye maturusi ekusimudzira, Oracle Database Express Edition inopa dzimwe nzira dzekuwana ruzivo, senge maonero uye akachengetwa maitiro. Maonero anochengetwa ⁤SQL queries inogona kubatwa sematafura chaiwo, zvichikubvumidza kuti uwane chaiyo data zviri nyore. Maitirwo akachengetwa ndeye SQL zvinyorwa zvinochengetwa mudhatabhesi uye zvinoitwa zvadzokororwa kana pakudiwa. Aya mamwe mabasa anonyanya kubatsira pakuita ongororo munguva chaiyo kana kugadzirisa mavhoriyamu makuru e data nzira inoshanda. Muchidimbu, Oracle Database Express Edition inopa huwandu hwakawanda hwesarudzo dzekuwana uye kuwana ruzivo rwune chekuita netafura zvinobudirira uye zviri nyore.

-Kubatanidza kune ⁤ database ⁤uye kuwana matafura

Kubatanidza kune database: Oracle Database Express Edition (Oracle XE) ndeyemahara, isina huremu vhezheni yeOracle Database inogonesa manejimendi edhatabhesi. Kumisikidza kubatana kune Oracle XE dhatabhesi, iyo Java programming mutauro uye Oracle's JDBC (Java Database Connectivity) inoshandiswa. Zvakakosha kutaura kuti maraibhurari eOracle JDBC anofanirwa kutorwa nekuiswa kuti abatanidze nemazvo.

Kusvika kumatafura: Kana iyo yekubatanidza kune Oracle XE dhatabhesi yasimbiswa, zvinokwanisika kuwana matafura uye kuwana ruzivo rwakabatana navo. Kuti uite izvi, SQL (Yakarongwa Query Mutauro) mibvunzo inoshandiswa kuburitsa data kubva mudhatabhesi. Mamwe emabasa ekutanga anogona kuitwa kubvunza marekodhi ane SELECT clause, kuisa zvinyorwa zvitsva neINSERT clause, kugadzirisa marekodhi aripo neUPDATE clause, uye kudzima marekodhi ne⁣ DELETE clause.

Wana ruzivo rwakabatana netafura: ‍ Kuti uwane ruzivo rwakakwana nezvetafura muOracle XE, unogona kushandisa SQL mibvunzo senge inotevera: SARUDZA * ⁢FROM tafura_name. Uyu mubvunzo unodzosa ese marekodhi uye makoramu⁢ etafura yakataurwa. Pamusoro pezvo, zvinokwanisika kushandisa zvirevo zvakaita sekuti WHERE kusefa zvabuda kana JOIN kubatanidza ruzivo kubva kumatafura akati wandei ane hukama. Izvo zvinobatsirawo kuziva chimiro chetafura, ndiko kuti, mazita nemhando dzedata dzekoramu yega yega, inogona kuwanikwa uchishandisa mubvunzo unotevera: TSANANGURA tafura_name. Uyu mubvunzo unoratidza ruzivo rwakadzama nezve tafura chimiro, kusanganisira iyo column zita, rudzi rwe data, uye humwe hunhu. Neruzivo urwu, zvinokwanisika kuita mimwe mibvunzo uye kuwana ruzivo rwaunoda nemazvo.

-Yakakosha mibvunzo kuti uwane ruzivo kubva patafura muOracle Express

Rimwe remabasa akakosha akaitwa muOracle Database Express ‍ Edition kuwana ⁣ruzivo rwune hukama⁤ kumatafura aripo. Izvi zvinowanikwa nekuita zvakakosha mibvunzo inotitendera kuti titore data inodiwa pakuongorora kwedu. Pazasi pane mimwe mibvunzo yakakosha kuti uwane ruzivo kubva patafura muOracle Express:

Mubvunzo wekuona chimiro chetafura: Kuona chimiro cheimwe tafura, tinogona ⁢kushandisa iyo⁤ chirevo TSANANGURA. Isu tinongo nyora ⁤murairo uchiteverwa nezita⁤ retafura, uye Oracle ichatiratidza rondedzero yemakoramu, marudzi e data uye zvirambidzo zvinoenderana.

Mubvunzo wekutora marekodhi kubva patafura: Kana tichida kuona marekodhi akachengetwa mutafura, tinogona kushandisa ⁤ clause. SARUDZA. Tichishandisa mubvunzo uyu, tinogona kusarudza makoramu ese kana kutsanangura chete ayo atinoda kuratidza. Uyezve, tinogona kushandisa chirevo KUPI kusefa mibairo zvichienderana nemamiriro ezvinhu.

Mubvunzo wekuverenga nhamba yezvinyorwa mutafura: Kana tichida kuwana huwandu hwehuwandu hwezvinyorwa mutafura, tinogona kushandisa basa rekubatanidza ZVINHU ZVINOVERENGA ⁢ pamwechete⁤ ne⁤mutsara SARUDZA. Isu tinongofanirwa kudoma zita retafura uye koramu yatinoda kuverenga. Oracle ichaita kuverenga uye inotiratidza mhedzisiro.

-Kushandisa SELECT clause kusarudza chaiwo makoramu

Kuburikidza⁤ iyo SELECT clause muOracle Database Express Edition, tinogona kuwana ruzivo rwakakwana kubva patafura. Ichi chinyorwa chinotibvumira kusarudza⁤ makoramu atinoda kuratidza mu⁢ zvawanikwa zvemubvunzo wedu. Izvi zvinonyanya kukosha kana tiri kushanda nematafura ane nhamba huru yemakoramu uye isu tinongoda mamwe minda yekuongorora kwedu.

Kuti tishandise SELECT clause, isu tinongoda kutsanangura makoramu atinoda kusarudza mushure meizwi rakakosha. Semuyenzaniso, kana tiine tafura inonzi “customers” ine makoramu akaita sezita, kero, foni, uye email, tinogona kushandisa. SARUDZA zita, kero kuwana chete ⁤ruzivo⁣ ine chekuita neaya mativi maviri chaiwo mumubvunzo wedu.

Isu tinogona zvakare kushandisa SELECT clause kutumidza zita makoramu mumibairo yedu. Izvi zvinowanikwa⁢ uchishandisa izwi rekiyi AS zvichiteverwa nezita ratinoda kuvapa. Semuenzaniso, kana isu tichida kuti zita rezita riratidze se "Zita reMutengi" mumhedzisiro yedu, tinogona kunyora ⁢ SARUDZA zita AS "Zita reMutengi". Izvi zvinogona kubatsira kana tichida kuita kuti mibairo iverengeke zvakanyanya kana kuti tichida kugadzirisa mafomati emishumo yedu.

-Kusefa data uchishandisa iyo WHERE clause muOracle Express

Iyo WHERE clause muOracle Express chishandiso chinobatsira pakusefa data uye kuwana ruzivo rwakanangana netafura muOracle Database Express Edition. Nechirevo ichi, vashandisi vanogona kutsanangura mamiriro ayo marekodhi anofanira kusangana kuitira kuti abatanidzwe mumhedzisiro yemubvunzo. Izvi zvinokutendera kuti uwane mamwe chaiwo uye anoenderana mhinduro.

Kuti ushandise chirevo cheWHERE, chinofanira kuverengerwa mushure meiyo SELECT keyword mumubvunzo weSQL Pakati pevashandisi vakajairika vanogona kushandiswa muWHERE clause vaenzanisi (<, >, = , <=, >=), the KUFANANA neopareta kutsvaga mapatani, uye BETWEEN opareta kudoma huwandu.

Pamusoro pevashandisi vataurwa pamusoro, iyo WHERE clause inobvumirawo akawanda mamiriro kuti abatanidzwe uchishandisa zvine musoro vanoshanda UYE uye OR. Nenzira iyi, mimwe mibvunzo yakaoma inogona kuitwa uye mimwe mibairo chaiyo inogona kuwanikwa. Zvakakosha kucherechedza kuti kurongeka kwakanyorwa mamiriro acho kunogona kukanganisa chigumisiro, sezvo ichiongororwa kubva kuruboshwe kuenda kurudyi.

-Kuronga mibairo neORDER BY clause

Kuronga mibairo uchishandisa ORDER BY clause

The clause⁤ ODHA NE muOracle Database Express Edition chishandiso chine simba chinotibvumira kugadzirisa mhedzisiro yemubvunzo mukukwira kana kudzika kurongeka. Nekushanda uku, tinogona kuronga ruzivo rwakawanikwa kubva patafura nenzira inoita kuti zvive nyore kududzira nekuongorora.

Kushandisa clause ODHA NE, tinongofanira kudoma nzvimbo imwe chete kana yakawanda yatinoda kugadzirisa mibairo. Pamusoro pezvo, isu tinokwanisa kuratidza kwainoronga tichishandisa mazwi akakosha ASC yekukwira kana DESC zvekuburuka. Semuyenzaniso, kana tichida kuronga mibairo nendima ⁢»zita» mukukwira kurongeka, tinogona kuwedzera chirevo cheSQL chinotevera⁢ kumubvunzo wedu:

SELECT * FROM tabla_ejemplo ORDER BY nombre ASC;

Zvakakosha kuchengeta mupfungwa⁢ izvozvo ORDER⁢ BY Icho chikamu chesarudzo uye kana chisina kutaurwa, mibairo icharatidzwa muhurongwa hwavanochengeterwa mutafura. Nekudaro, nekushandisa chikamu ichi tinogona kuwana zvakarongeka uye zvinonzwisisika mhedzisiro, izvo zvinoita kuti zvive nyore kuongorora ruzivo.

-Kudzikamisa huwandu hwemarekodhi ane LIMIT clause

Kuganhurira nhamba yemarekodhi ane LIMIT clause

MuOracle Database Express Edition, iyo MUGANHU Icho chishandiso chinobatsira kwazvo kudzikamisa nhamba yezvinyorwa zvakadzoserwa mumubvunzo. Ichi chirevo chinoshandiswa pamwe chete nechirevo ⁤ SARUDZA kuti titaure kuti marekodhi mangani atinoda kuwana kubva kune imwe tafura Neizvi, tinogona kuderedza basa rehurongwa uye nekumhanyisa mibvunzo yedu.

Kushandisa clause MUGANHU muOracle, tinongowedzera MUGANHU ichiteverwa nenhamba mushure mechirevo SARUDZA. Semuenzaniso, kana tichida kuwana zvinyorwa gumi zvekutanga zvetafura inonzi clientes,mubvunzo wedu ungave:

SARUDZA * 
FROM clientes
MUGANHU 10;

Nemubvunzo uyu, tichangowana zvinyorwa gumi zvekutanga zvetafura clientes. Izvi zvinogona kunyanya kubatsira kana isu tiri kushanda nemahombe dhatabhesi ⁢uye tinongoda kuratidza chikamu chidiki cheruzivo. Uyezve, tinogona kubatanidza mutsara MUGANHU nezvimwe zvirevo uye mamiriro kuti uwane mamwe chaiwo uye akakodzera mhedzisiro.

-Kushandisa aggregation mabasa kuwana pfupiso ruzivo

Kushandisa Aggregation Mabasa Kuti Uwane Summary Ruzivo

MuOracle Database Express Edition, kune akati wandei mabasa ekubatanidza atinogona kushandisa kuwana pfupiso ruzivo kubva patafura. Aya mabasa anotitendera kuti tiite masvomhu mumakoramu enhamba uye kuwana mibairo yakadai seavhareji, uwandu, kukosha kwepamusoro kana kushoma, pakati pezvimwe.

Imwe yeanowanzo shanda ndeye AVG(), iyo inotibvumira kuverenga avhareji yezvikoshi mukoromo. Semuenzaniso, kana tiine tafura yekutengesa ine mutengo⁤ column, tinogona kushandisa iyo⁢ AVG() basa kuti tiwane avhareji yemitengo yezvinhu zvese zvinotengeswa.

Rimwe basa rinobatsira ndiro SUM(), izvo zvinotibvumira kuverenga huwandu hwezvikoshi mukoramu. Kana tiine tafura yemuhoro ine koramu yezvitsama, tinogona kushandisa iyo SUM () basa kuti tiwane mari yese inowanikwa panguva nguva chaiyo. Mukuwedzera⁢ kuAVG () uye SUM (), tinogona zvakare kushandisa mabasa akadai MAX() kuwana kukosha kwepamusoro kwekoramu kana MIN() kuti uwane kukosha kwakaderera.

Aya mabasa ekuunganidza anobatsira zvikuru kana tichida kuwana ruzivo rwechidimbu kubva patafura muOracle Database Express Edition. Nekushandisa mabasa aya, tinokwanisa kuita masvomhu pamakoramu enhamba uye towana mibairo yakaita seavhareji, uwandu, huwandu kana kukosha kushoma. Izvi zvinotibvumira kuwana mhedziso yedata nenzira iri nyore uye nekukurumidza. Pamusoro pezvo,⁤ mashandiro aya anogona kusanganiswa nemamwe ma clause emubvunzo, sekuti WHERE kana GROUP BY, kuti uwane zvakanyatsojeka ⁤uye ⁤zvakananga.

-Kuwana rumwe ruzivo kuburikidza netafura inojoinha muOracle Express

Kuwana rumwe ruzivo uchishandisa tafura inojoinha muOracle Express

Kushandisa tafura inojoinha muOracle Database Express Edition ndeye nzira inoshanda kuti uwane rumwe ruzivo rwakabatana netafura huru. Kujoinha kwetafura kunobvumidza iwe kusanganisa data kubva kumatafura maviri kana anopfuura kuti uwane mibairo yakakwana uye kupfumisa ruzivo rwunodiwa mune chaiyo mubvunzo. MuOracle Express, mhando dzakasiyana dzekujoinha dzinogona kuitwa, sekujoinha kwemukati, kujoinwa kuruboshwe uye kujoina kurudyi, zvichienderana nedata raunoda kuwana. Kushandisa tafura kujoinha kunobvumidza iwe kutora mukana wakazara weOracle Express kugona kubata hombe data seti uye kuwana chaiyo⁢ uye yakazara mhedzisiro.

Kuita tafura kujoinha muOracle Express, zvinodikanwa kuti uone makoramu akajairwa pakati pematafura aunoda kujoinha uye kutsanangura kuti data racho rinofanira kusanganiswa sei. Paunenge uchishandisa tafura yekujoinha, zvakakosha kuti titarise mhando yehukama huripo pakati pematafura, ingave hukama 1-ku-1, 1-kune-vazhinji, kana kuwanda-kune-vakawanda hukama. Zvichienderana nehukama uhwu, mhando yakakodzera kwazvo yekujoinha inofanirwa kusarudzwa kuti uwane ruzivo rwaunoda. Kana matafura achinge abatanidzwa, zvikamu zvakasiyana, sekuti WHERE uye ORDER BY, zvinogona kushandiswa kukwenenzvera uye kuronga zvawanikwa.

Tafura inojoinha muOracle Express inopa kuchinjika kuti uwane rumwe ruzivo rwakanangana netafura huru, ichibvumira kune yakazara yakazara uye yakadzama mibvunzo. Nekubatanidza data kubva kumatafura akasiyana, zvinokwanisika kuwana ruzivo rwusingawanikwe mune yega tafura, senge data revatengi rine chekuita nemirairo, zvigadzirwa zvinotengeswa mune imwe chikamu, kana vashandi vakapihwa kune chaiwo mapurojekiti. Ruzivo rwekuwedzera urwu runogona kuve rwakakosha pakuita sarudzo neruzivo uye kuwana mufananidzo wakazara weiyo data yakachengetwa muOracle Express Tafura inojoinha chinhu chakakosha chekuwedzera kukosha kwedata uye kugadzirisa kuongorora uye kuita sarudzo muOracle Express.