Kubalulekile ukuhlala unolwazi ngenguqulo yesofthiwe ye-Oracle Database esisebenza nayo njengoba ithinta kakhulu ukusebenza nokusebenza kwamakhodi nemibuzo esiyisebenzisayo. Lesi sihloko sidingida izindlela zokubuyisa inguqulo ye-Oracle Database. Injini ye-Oracle SQL isebenzisa izici eziningi nemisebenzi engenza kube lula kakhulu inqubo yokubuyisa inguqulo. Lesi sihloko sizohlomisa umfundi ngolwazi kanye namazwibela ekhodi ayisisekelo, nokho abalulekile adingekayo ukuze kutholwe inguqulo ye-Oracle Database.
I-Oracle Database iwuhlelo oluqinile lwe-otho-relational database management system (RDBMS) olukhiqizwe yi-Oracle Corporation. I-Oracle Database ibizwa ngokuthi i-Oracle RDBMS noma i-Oracle nje. Ngokusebenzisa i-Oracle SQL, abathuthukisi bangaphatha inani elikhulu ledatha futhi basebenzise izixazululo eziqhutshwa idatha.
KHETHA * KUSUKA ku-v$version;
Umyalo ongenhla unikeza inguqulo yesizindalwazi se-Oracle oxhumeke kuso. I-`v$version` iwukubuka okugxilile okunikeza imininingwane yenguqulo yezingxenye ezihlukene zesenzakalo se-Oracle, okuhlanganisa inguqulo Yedathabhesi ye-Oracle.
Ake siphule umyalo:
`KHETHA *` - Le ngxenye yombuzo we-Oracle SQL ikhuthaza iseva ukuthi ikhethe zonke izinkambu (amakholomu) atholakala kuthebula elishiwo, elithi `v$version` kulesi simo.
`KUSUKA ku-v$version;` - Le ngxenye yomyalo we-SQL icacisa ukubuka okugxilile kwesizindalwazi se-Oracle okudingeka sikubuze ukuze sibuyise imininingwane yenguqulo.
Ukuqonda inguqulo ye-Oracle DB
Uma umyalo othi `KHETHA * KUSUKA ku-v$version;` usetshenziswa, ulanda amarekhodi avela ezingxenyeni ezihlukene zokufakwa kwe-Oracle Database. Nokho, ukuze sithole ulwazi olunembile mayelana nenguqulo yesizindalwazi, singasebenzisa umyalo olandelayo:
KHETHA * KUSUKA ku-v$version LAPHO isibhengezo NJENGO 'Oracle%';
Usebenzisa isigatshana esithi `LAPHO` esithi `NJENGATHI 'Oracle%'`, umyalo uzobuyisela kuphela inguqulo yesizindalwazi se-Oracle, ungaziba imininingwane evela kwezinye izingxenye.
Ukuqonda imininingwane egcwele yenguqulo yesizindalwazi se-Oracle kubalulekile njengoba inombolo yenguqulo ihlukaniswe yaba izingxenye ezinhlanu: inombolo enkulu yokukhishwa kwesizindalwazi, inombolo yokukhishwa kokugcinwa kwesizindalwazi, inombolo yokukhishwa kweseva yohlelo lokusebenza, inombolo yokukhishwa kwengxenye ethile, kanye nenombolo yokukhululwa eqondene nenkundla.
Ukusebenzisa Imitapo yolwazi ye-Oracle SQL kanye nemisebenzi
I-Oracle SQL ihlanganisa imisebenzi eminingi eyenza kube lula ukukhohliswa kanye nemibuzo yesizindalwazi se-Oracle. Kusukela ekubalweni kwezibalo ezithile kuye ekuphatheni amanani edethi/isikhathi kanye nokukhohliswa kweyunithi yezinhlamvu, le misebenzi yenza i-Oracle SQL ibe nezinto ezihlukahlukene.
Ngomongo wokubuyisa inguqulo Yesizindalwazi se-Oracle, `v$version` iwukubuka kwesistimu okubalulekile okwamukela ulwazi oludingekayo. Isigatshana esithi `LAPHO` kanye nomsebenzisi we-wildcard `%` sisiza ukuhlunga idatha efiswayo.
Khumbula , ukwazi i-Oracle SQL kuhilela ukusebenzisa lawa malabhulali, imisebenzi, imibono yesistimu, nokuqonda ukusebenzisana kwawo ukuze kwakhiwe izixazululo ngempumelelo. Hlola umhlaba ohlukahlukene we-Oracle SQL ukuze usebenzise amandla ayo aphezulu ekuphathweni kwedatha.
Qaphela , le mibuzo izosebenza kuphela uma unamalungelo/izimvume zokufinyelela umbono we-v$version. Uma ubhekene nenkinga ngemvume, xhumana noMqondisi wakho Wedathabheyisi.
