Ndingabatana sei neOracle Database Express Edition kubva kuSQL Developer?

Maitiro ekubatanidza kune ⁢Oracle Database ⁢Express Edition kubva kuSQL Developer?

Batanidza ku Oracle Database Express Edition kubva kuSQL Developer inhanho yakakosha⁤ kune vese vanoshanda navo madhatabhesi Oracle. SQL Developer chishandiso chine simba chekusimudzira chinopa iri nyore kushandisa graphical interface uye kuwanda kwekushanda kwekutonga, kubvunza, uye kuchengetedza Oracle dhatabhesi. Muchinyorwa chino, isu tichaongorora matanho anodiwa kumisikidza yakabudirira kubatana pakati peOracle Database Express Edition uye SQL Developer. Kana iwe uri mutsva kupasi reOracle kana uchingoda kuzorodza ruzivo rwako, verenga kuti uwane nzira yekubatanidza aya maturusi ane simba.

1. Dhawunirodha Oracle Database Express Edition

Yekutanga ⁢danho rekubatanidza⁢ Oracle Database Chinyorwa cheExpress SQL Developer ndeyekuita shuwa kuti une Express edition yeOracle dhatabhesi yakaiswa. Iyi yemahara, yakareruka edition inopa yakasimba chikuva chekugadzira uye yekuyedza maapplication anoshandisa Oracle. ⁢Unogona kuidhawunirodha zviri nyore kubva ku webhusaiti Oracle official uye tevera mirairo yekuisa yakapihwa.

Kana uchinge wadhawunirodha uye ⁤kumisikidza Oracle Database Express Edition, wagadzirira kumisa chinongedzo kubva kuSQL Developer.

2. Vhura SQL Developer

Vhura SQL Developer pachikwata chako uye mirira kuti itakure zvachose. Iwe unogona kuwana iyo purogiramu mune yekutanga menyu kana munzvimbo yawakaiisa. Hongu ndiwe uyu kekutanga Uchishandisa SQL Developer, ungangoda kugadzirisa zvimwe zvekutanga zvaunofarira, sekuseta nzvimbo yeJava JDK kana isina kungoonekwa.

Kana SQL Developer yatanga zvinobudirira, wagadzirira kuseta nyowani yekubatanidza kuOracle. Dhijitari yeExpress yeDatabase.

3.⁤ Gadzirisa chinongedzo kuOracle ⁢Database Express Edition

MuSQL Developer, tinya iyo "Faira" menyu uye sarudza "Itsva Yekubatanidza." Iwindo rinobuda rinovhurika richikubvumidza kuti uise iyo inodiwa yekubatanidza data kuti ubatanidze kuOracle Database Express Edition.

Kuti ugadzirise chinongedzo, iwe unozofanirwa kutsanangura iyo inodiwa ruzivo, senge zita remushandisi uye dhatabhesi password, pamwe nezita remugamuchiri uye nhamba yechiteshi Iva nechokwadi chekuisa iyo chaiyo kukosha uye tinya "Test" kuti uone kubatanidza usati wachengeta.

Makorokoto! Iye zvino iwe wakabatana neOracle Database Express Edition kubva kuSQL Developer uye wakagadzirira kutora mukana weese maficha uye kugona kwezvishandiso zvese.

Mhedziso

Kubatanidza Oracle Database Express Edition kubva kuSQL Developer kwakakosha kune avo vanoshanda neOracle dhatabhesi. Nematanho ari pamusoro apa, unogona kuseta yakabudirira kubatana uye kutora mukana wakazara weese mabhenefiti anopihwa neaya maturusi ane simba. Gara uchiyeuka kuisa iyo chaiyo yekubatanidza ruzivo uye simbisa iyo yekubatanidza usati waichengeta. Zvino zvawave nezvose zvakamisikidzwa, ongorora uye edza nekusingaperi mikana iyo Oracle Database Express⁤ Edition uye SQL Developer yakakuchengetera!

- Prerequisites⁤ yekubatanidza kuOracle Database Express Edition kubva kuSQL Developer

Zvinotarisirwa kuti ubatanidze kuOracle Database Express Edition kubva kuSQL Developer

Usati wabatana neOracle Database Express⁢ Edition kubva kuSQL Developer, zvakakosha kuve nechokwadi kuti unosangana nezvimwe zvinodikanwa. Kutanga, iwe unofanirwa kuve nekumisikidzwa kweOracle Database Express Edition pane yako system. Izvo zvinodiwa⁢ kuve neshanduro 11g kana gare gare kuti ugone kushandisa SQL Developer nemazvo. Kuti utarise kana iwe uchitova nedhatabhesi yakaiswa, unogona kumhanya iyo "sqlplus" kuraira muhwindo rekuraira uye tarisa kana uchikwanisa kuwana dhatabhesi.

Pamusoro pezvo, zvinodikanwa kuve neshanduro yakagadziridzwa yeSQL Developer. Unogona kudhawunirodha yazvino vhezheni yeSQL Developer kubva kune yepamutemo Oracle webhusaiti. Ita shuwa kuti une yakagadzikana internet yekubatanidza panguva yekurodha nekuisa.

Kugadzirisa Kubatanidza kuOracle Database Express Edition kubva kuSQL Developer

Kana uchinge wasangana nezvinodiwa, unogona kuenderera mberi nekugadzirisa kubatana kuOracle Database Express Edition kubva kuSQL ⁣Developer. Vhura SQL Developer uye tinya "New Connection" mukati mudziyo wekushandisa. Iwe unozounzwa neiyo dialog hwindo kwauchazoda kuisa iyo yekubatanidza data.

Muchikamu che "Zita rekubatanidza", unogona kuisa zita rinotsanangura rekubatanidza kwako. Mundima ye "Username" uye "Password", isa zvitupa zveOracle dhatabhesi Ita shuwa kuti wakagadzirisa zita rekushandisa uye password nemazvo. Mu "Host ID" uye "Port" munda, isa IP kero uye chiteshi cheOracle dhatabhesi server yako zvichiteerana. Chekupedzisira, tinya "Test" kuti uone kuti kubatana kwakagadzwa nemazvo.

Mamwe Mafungiro eKubatanidza ku⁢ Oracle Database Express Edition kubva kuSQL Developer

Izvo zvakakosha kuti uzive kuti kana uri kushandisa chaiwo muchina kumhanyisa Oracle Database Express Edition, ungangoda kugadzirisa network yekubatanidza nenzira kwayo. Ita shuwa kuti wakagadzirisa iyo firewall mitemo uye uvhure madoko anodiwa kuti ubvumire kutaurirana neOracle dhatabhesi yako.

Pamusoro pezvo, kana server yako yeOracle ine IP kero kusefa yakagoneswa kana kushandisa iyo yekuwana control list (ACL), iva nechokwadi chekuwedzera IP kero yemuchina wako kana muchina chaiwo kune kero rondedzero.

Nezvinodikanwa izvi zvakakwana uye nekumisikidzwa kwayo muSQL Developer, unenge wakagadzirira kubatana neOracle Database Express Edition uye wotanga kushanda nedatabase rako.

- Dhawunirodha uye isa Oracle⁤ Database Express Edition uye⁢ SQL Developer

Kuti ubatanidze kuOracle Database Express Edition⁢ kubva kuSQL ⁣Mugadziri, ⁣ unofanira kutanga wadhawunirodha nekuisa zvese zvirongwa pakombuta yako. Oracle Database Express Edition ndeye yemahara, isina huremu vhezheni yeiyo yakakurumbira dhatabhesi manejimendi system. SQL Developer, kune rumwe rutivi, ndeye graphical yekuvandudza uye yekushandisa yekushandisa. yemadhatabhesi Oracle.

Danho rokutanga nderokuti download Oracle Database Express Edition kubva kune yepamutemo Oracle webhusaiti. ⁢Iva nechokwadi chekusarudza chaiyo ⁢version ye sisitimu yako yekushandisa. Paunenge uchinge wadhawunirodha faira rekuisa, tinya kaviri kuti utange maitiro ekuisa. Tevedza mirairo yepa-screen uye upe ruzivo rwunodiwa, senge nzvimbo yekuisa uye zvitupa zvemaneja.

Mushure mekunge yakaiswa Oracle Database Express Edition, unogona kuenderera kurodha uye kuisa SQL Developer. Zvekare, enda kune yepamutemo Oracle webhusaiti uye tsvaga iyo SQL Developer yekurodha peji. Dhawunirodha iyo yakakodzera yekuisa faira kune yako yekushandisa system uye imhanye. Panguva yekuisa, unogona kusarudza nzvimbo yekuisa uye dzimwe tsika dzesarudzo zvichienderana nezvaunoda. Kamwe kuisirwa kwapera, unogona kuvhura SQL Developer‍ kubva pakutanga menyu⁢.

-Yekutanga kumisikidzwa yeOracleDatabase Express Edition yekubatanidza kubva kuSQL Developer

Oracle Database Express Edition ndeyemahara, isina huremu vhezheni yeOracle's ⁢ine simba dhatabhesi manejimendi system. Kana iwe uchida kubatanidza kune iyi edition kubva kuSQL Developer, pano tinokuratidza maitiro ekuita inodiwa yekutanga kumisikidzwa. Kugadzirisa nemazvo ⁢kubatana⁤ pakati peOracle Database Express Edition neSQL Developer⁣ kwakakosha ⁤kuti ukwanise ⁢kutarisira dhatabhesi nemazvo.

1. Dhawunirodha uye isa Oracle Database Express Edition:

Usati watanga, ita shuwa kuti une Oracle Database Express ⁤Edition yakaiswa pamushini wako wemuno kana server. Unogona kuirodha kubva kune yepamutemo Oracle webhusaiti uye tevera iyo yekumisikidza mirairo yako sisitimu yekushandisa. Kana yangoiswa, ita shuwa kuti Oracle sevhisi iri kushanda.

2. Gadzirisa muteereri weOracle:

⁢ ⁤ ⁤Iye zvino unofanira kugadzirisa ⁤muteereri weOracle kuti ubvumire ⁤makonesheni kubva kuSQL ⁢Developer. Vhura iyo "muteereri.ora" yekumisikidza faira iri muOracle yekumisikidza dhairekitori uye ive nechokwadi chekuti "LISTENER" paramende yakarongedzerwa nemazvo,⁤ kusanganisira yakakodzera chiteshi chekuteerera. Tangazve sevhisi yeOracle kuti ushandise shanduko.
⁤

3. Batanidza kuOracle Database Express Edition ⁢kubva kuSQL Developer:

Vhura SQL Developer uye tinya pane "New Connection" sarudzo. ⁤Zadzisa minda yakakumbirwa, senge⁢ username, password uye host. Ita shuwa kuti waisa iyo chaiyo yekuteerera chiteshi uye zita rebasa reOracle Database Express Edition yako. Kana wangoisa ruzivo rwese rwunodiwa, tinya "Test" kuti uone kubatana uye wozo "Batanidza" kuti uzvimise. Ready! Iye zvino unogona kubata yako Oracle Database Express Edition dhatabhesi kubva kuSQL Developer.
‍

Exclusive content - Click Here  Chii chinopihwa neRedshift panyaya yekuchengetedza zvinhu?

-Kugadzirisa chinongedzo mu ⁤SQL Developer yekubatanidza kuOracle Database Express Edition

Kugadzirisa chinongedzo muSQL Developer yekubatanidza kuOracle Database Express Edition Inzira ⁢zvakareruka asi zvakakosha kune avo vanoda kuwana iyi dhatabhesi.⁢ Kuti utange, unofanirwa kuve neOracle Database Express Edition yakaiswa pane yako system. Paunenge uchinge uine dhatabhesi yakaiswa, unogona kuvhura SQL Developer uye uteedzere matanho ari pazasi kuti ugadzirise kubatana.

Chekutanga pane zvese, unofanirwa kuvhura SQL Developer uye wosarudza iyo "New Connection" sarudzo kubva ku "Faira" menyu.⁤ Izvi zvinokutora iwe kuhwindo kwaunogona kuisa yako yekubatanidza data. Mu "Basic" tab, iwe uchafanirwa kupa zita rekubatanidza uye zita rezita rekushandisa uye password. Iwe zvakare unozofanirwa kuisa iyo server IP kero mu "Host zita" munda. Kana iwe uri kushandisa Oracle Database Express Edition pakombuta yako, unogona kuisa "localhost" sezita remuenzi.

Zvadaro, unofanira kugadzirisa "Advanced Options" tab. Apa ndipo paunogona kutsanangura chiteshi chekubatanidza uye⁢ zita rebasa re database. Iyo yakasarudzika chiteshi cheOracle Database Express Edition ndeye 1521, asi kana iwe ukagadzirisa imwe chiteshi panguva yekuisa, iwe unozofanirwa kuisa iyo kukosha pano. Uyezve, iwe unofanirwa kuisa zita rebasa re database mu "Zita rebasa" ndima. Kazhinji, zita rebasa rekutanga ndi "xe," asi kana wakarichinja panguva yekuisa, unozofanirwa kuisa zita idzva pano.

-Kukanganisa kwakajairika paunenge uchiedza kubatana neOracle Database Express Edition kubva kuSQL Developer

Kanganiso 1: Magadzirirwo asina kunaka emuteereri

Imwe yezvikanganiso zvakajairika paunenge uchiedza kubatana neOracle Database Express Edition kubva kuSQL Developer igadziriso yevateereri isiriyo. Muteereri inzira inoteerera zvikumbiro zvekubatanidza database uye inotungamira kune yakakodzera server. Kana isina kurongeka nenzira kwayo, SQL ⁣Developer haizokwanisi kumisikidza yakabudirira kubatana.

Kugadzirisa dambudziko iri, zvinodikanwa kuona kuti muteereri ari kushanda nemazvo. Iwe unogona kuita izvi nekushandisa iyo lsnrctl mamiriro ekuraira pane yekushandisa system command line. Kana mutereri ari pasi kana kuratidza chero zvikanganiso, ungangoda kuitangazve kana kuigadzirisa nemazvo Kune akati wandei epamhepo zviwanikwa zvinogona kukutungamira mukuita uku.

Kukanganisa 2: Zita re database risiriyo

Chimwe chikanganiso chakajairika kuyedza kubatanidza ⁤to⁣ dhatabhesi nezita risiri iro. Zvakakosha kuyeuka kuti zita re database rinogona kunge rakasiyana kubva kune zita rekugamuchira revhavha Kana ukaedza kushandisa zita rekugamuchira panzvimbo yezita re database paunenge uchibatanidza kubva kuSQL Developer, unogona kugamuchira meseji yekukanganisa.

Kugadzirisa dambudziko iri, ita shuwa kuti une zita rakakodzera re database paunenge uchiedza kumisikidza chinongedzo kubva kuSQL Developer. Iri zita rinowanzo kuwanikwa mune zvinyorwa kana mune dhatabhesi configuration Kana uchiri kunetseka, unogona kuedza kushandisa server's IP kero panzvimbo zita remugamuchiri kuti utange kubatana.

Kukanganisa 3: Zvinyorwa zvisiri izvo

Iko kukanganisa kwakajairika paunenge uchiedza kubatana neOracle Database Express Edition kubva kuSQL Developer iri kuisa zvisizvo zvitupa. Izvo zvakakosha kuve nechokwadi chekuti uri kushandisa chaiyo username uye password paunenge uchigadzira kubatana. Kana iwe ukagamuchira meseji yemhosho ine chekuita nemagwaro, nyatso tarisa ruzivo rwauri kuisa.

Kana usina chokwadi nezveruzivo rwakakwana, unogona kuedza kuzviseta patsva uchishandisa maturusi akapihwa neOracle Neimwe nzira, unogona kubata maneja wedatabase yako kana kubvunza zvinyorwa zveOracle kuti uwane rumwe ruzivo nezve ⁤the​ dura ⁤uri kuyedza kubatana ne.

-Kurudziro yekukwirisa kuita kana uchinge wabatana neOracle⁢ Database Express⁢ Edition kubva kuSQL Mugadziri

Step 1: Dhawunirodha uye isa SQL Developer

Usati watanga, unofanirwa kurodha uye kuisa SQL Developer pakombuta yako. Unogona kuwana yazvino vhezheni yeSQL Developer kubva kuOracle yekurodha saiti. Ita shuwa kuti unosarudza kugovera kwakaringana⁢ kune yako yekushandisa system.

Mushure mekudhawunirodha yekuisa faira, tevera mirairo kuti upedze iyo yekuisa. Kana yangoiswa, mhanya SQL Developer kuti utange kuigadzirisa.

Danho 2: Gadzirisa kubatana kutsva kune database

Kana uchinge wavhura SQL⁣ Mugadziri, sarudza iyo "New Connection" sarudzo kubva ku "Faira" menyu. Izvi zvinovhura hwindo rekugadzirisa kwaunofanirwa kuisa data rekubatanidza kune yako Oracle dhatabhesi. Ita shuwa kuti une iyo chaiyo IP kero, chiteshi, zita rekushandisa, uye password paruoko.

Kana uchinge wapedza minda yeruzivo, tinya "Test" kuti uone kubatana.

Danho rechitatu: gadzirisa kushanda kwekubatanidza

Kana yangobatanidzwa kune yako Oracle dhatabhesi, pane akati wandei kurudziro iwe aunogona kutevera kuti uwedzere kuita kana uchishandisa SQL Developer. Zvimwe zvezvikumbiro izvi zvinosanganisira:

• Deredza nhamba⁢ yemarekodhi akatorwa: Kana uri kubvunza mibvunzo inodzosa data yakawanda,⁤ shandisa LIMIT clause kudzikamisa huwandu hwemarekodhi atorwa. Izvi zvinoderedza mutoro pane sevha uye kuvandudza maitiro emubvunzo.
• Shandisa indekisi yakakodzera: Ita shuwa kuti matafura ane ma indexes akakodzera emibvunzo inowanzo mhanya. ⁢Maindekisi anobatsira kukurumidze kubvunza nekubvumira kukurumidza⁢ kuwana data.
• Dzivisa mibvunzo isina basa: Dzivisa kubvunza mibvunzo isingakodzeri kune chinangwa chako. Izvi zvichabatsira kuderedza nguva yekuuraya uye kushandisa zviwanikwa.

-Kushandisa anobatsira mabasa uye mirairo⁢ muSQL⁤ Mugadziri kushanda neOracle Database Express Edition

Kushandisa mabasa anobatsira uye mirairo muSQL Developer kushanda neOracle Database Express Edition

MuSQL Developer, kana uchibatana neOracle Database Express Edition, kune akati wandei anobatsira mabasa uye mirairo inoita kuti kushanda nedhatabhesi kuve nyore. Aya maficha anotendera iwe kurerutsa uye nekumhanyisa manejimendi nekusimudzira mabasa muOracle.

1. Chinhu Muongorori
The object explorer in SQL ⁣Developer chishandiso chakakosha⁢ chekufambisa nekuona nekuona zvakasiyana siyana zvedatabase.⁣ Kubva pahwindo iri, unokwanisa kukurumidza kuwana⁢ matafura, maonero, maitiro akachengetwa, kutevedzana uye zvimwe zvinhu zvedatabase. Pamusoro pezvo, zviito zvakasiyana zvinogona kuitwa pazvinhu izvi, sekuona kana kugadzirisa chimiro chazvo, kuita mibvunzo uye kugadzirisa data zvakananga.

2. SQL Editor
Iyo SQL Mharidzo muSQL Developer⁢ inokutendera iwe kunyora uye kumhanyisa mibvunzo zvakananga mudhatabhesi Inonyanya kubatsira kana iwe uchida kuita mibvunzo yakaoma kana iwe paunenge uchida kugadzira mashandiro etsika kana maitiro akachengetwa. kodhi autocompletion, uye koni yemhedzisiro uko mhinduro dzemubvunzo dzinoratidzwa.

3. Report jenareta
Iyo inovaka mushumo muSQL Developer chishandiso chine simba kugadzira uye gadzirisa yakadzama mishumo pane data mudhatabhesi. Inokutendera kuti usarudze iwo chaiwo matafura uye makoramu aunoda kuisa mushumo, pamwe nekuisa mafirita uye kuronga. Inopawo sarudzo dzekugadzirisa uye nekuona dhizaini repoti, sekuwedzera misoro, tsoka, uye machati.

Muchidimbu, SQL Developer inopa akasiyana emabasa anobatsira uye mirairo yekushanda neOracle Database Express Edition. Iyo Object Explorer, SQL Mharidzo, uye Report Builder angori mashoma ezvishandiso anoratidzwa anoita kuti kugadzira uye kubata dhatabhesi muOracle kuve nyore. Nezvimiro izvi, vashandisi vanogona kukwirisa basa ravo uye kuwedzera kugadzirwa kwavo.