I-Oracle Application Express, evame ukwaziwa nge-Oracle APEX, isizuze ukuduma okukhulu phakathi konjiniyela ngokusebenza kwayo okuphezulu kanye nesixhumi esibonakalayo esisebenziseka kalula. Ithuluzi eliqinile lisiza ekwakheni izinhlelo zokusebenza zewebhu eziyinkimbinkimbi ezisekelwa isizindalwazi se-Oracle. Ngaphezu kwalokho, iyindawo enekhodi ephansi, evumela onjiniyela abanolwazi oluncane ukuthi bakhe izinhlelo zokusebenza.
I-Oracle APEX inikeza izinguqulo ezihlukahlukene, ngayinye iletha izici ezithuthukisiwe namathuluzi enqubo yokuthuthukiswa eyenziwe lula nephumelelayo. Ukuvela okuhamba ngokushesha kwe-Oracle APEX kungakwenza kube inselele ukulandelela umehluko phakathi kwalezi zinguqulo.
Uma kubhekwa ubunzima kanye nokuvela okuqhubekayo kwe-Oracle APEX, kubaluleka ukuqonda ukusebenza kwezinguqulo zayo ezihlukile. Ngokuvamile, onjiniyela bangase bafune ukubuza inguqulo ye-Oracle APEX esetshenziselwa ukulungisa ukusebenza, ukusebenzisa amapeshi, noma ukuxazulula inkinga.
Thola i-Apex Version View
Ukukhishwa kwenguqulo ye-Oracle APEX kwenza inqubo yokuxazulula izinkinga ibe lula futhi yethule ukucaca okwengeziwe endaweni yokuthuthukiswa. I-Oracle SQL ingasetshenziswa ukuthola ulwazi oludingekayo.
Ukubuka kwesichazamazwi sedatha ye-Oracle 'APEX_RELEASE' kugcina imininingwane yenguqulo ye-APEX.
Nawu umbuzo odingekayo we-SQL ukuze ulande inguqulo ye-Oracle APEX:
KHETHA inguqulo_no
KUSUKA APEX_RELEASE;
Ake sihlukanise ikhodi ye-SQL futhi sihlaziye izingxenye zayo:
- Isitatimende esithi KHETHA sisetshenziselwa ukubuyisa idatha ethile kusizindalwazi se-SQL.
โ version_no ihambisana nekholomu kuthebula elithi 'APEX_RELEASE' eliphethe imininingwane yenguqulo ye-APEX.
Imitapo yolwazi ye-Oracle SQL kanye nemisebenzi
Njengohlelo lokuphathwa kwesizindalwazi esihlobene, i-Oracle SQL inomtapo wezincwadi obanzi wemisebenzi eyakhelwe ngaphakathi esiza ekuguquleni idatha.
Imisebenzi ye-Oracle SQL ihlukaniswe kabanzi ngalezi:
- Imisebenzi yomugqa owodwa: Lezi zikhohlisa izinto zedatha futhi zibuyisela umphumela owodwa umugqa ngamunye.
- Imisebenzi yemigqa eminingi noma i-Aggregate: Babuyisela umphumela owodwa weqembu lemigqa.
- Imisebenzi yokuguqula: Baguqula inani ukusuka kolunye uhlobo lwedatha ukuya kolunye.
Ukuze siqoqe imininingwane ethuthukisiwe, sivamise ukuhlanganisa imisebenzi elula ye-SQL ukuze sakhe izixazululo eziyinkimbinkimbi neziguquguqukayo.
Sengiphetha, ukuqonda izinguqulo ezihlukahlukene ze-Apex, ukusebenza kwazo, nemitapo yolwazi ye-Oracle SQL kanye nemisebenzi esebenza nazo kubalulekile ukuze kusetshenziswe isofthiwe ngendlela efanele ukuze ithuthuke ngaphandle komthungo.