Kuxazululiwe: ukubuka kwenguqulo ephezulu

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.

Okuthunyelwe okuhlobene:

Shiya amazwana