Ixazululiwe: sql log to console

Emhlabeni wohlelo lwe-Oracle SQL, esinye sezici ezibalulekile okudingeka kubhekwane nazo, sihlanganisa ukuloga kwemicimbi noma imisebenzi ezoduduzwa. Ikhonsoli yakha ingxenye ebalulekile yokuhamba komsebenzi wokulungisa iphutha, ihlinzeka onjiniyela indlela yokulandelela ukusebenza kwesistimu, okuhlanganisa nokukhomba izindawo lapho izinkinga zingase zenzeke khona. Lesi sihloko sidingida lesi sici esibaluleke kakhulu.

I-Oracle SQL, ukuba inkundla enkulu futhi ebanzi, kungase kubangele izinselelo ezithile ezihlukile kubathuthukisi, ikakhulukazi uma kuziwa ekungeneni kwekhonsoli, nokho, izixazululo zikhona ukuze kube lula le nqubo.

QALA
DBMS_OUTPUT.ENABLE;
DBMS_OUTPUT.PUT_LINE('Umlayezo wakho welogi uya laphaโ€ฆ');
Ukuphela;

Lesi siqeshana sekhodi ye-Oracle SQL singaba yisisekelo sesistimu yakho yokugawula. Ucingo lomsebenzi othi `DBMS_OUTPUT.ENABLE` yilo oluvula okukhiphayo kwekhonsoli kuseshini yakho, futhi kungemuva kokwenza lokhu kuphela lapho uyokwazi khona ukuloga noma yimiphi imilayezo.

Ukuqonda ikhodi ye-Oracle SQL yokungena kwe-Console

Ingqikithi yekhodi yethu yokungena ye-Oracle SQL yiphakheji `DBMS_OUTPUT`, ehlinzeka ngezindlela zokubonisa okukhiphayo, ulwazi lokungena, noma imilayezo yokususa iphutha.

Ikholi ethi `DBMS_OUTPUT.ENABLE` ekuqaleni kwebhulokhi ye-PL/SQL iyalela i-Oracle SQL ukuthi iqale ukufaka kubhafa okukhiphayo okuvela kokuthi `DBMS_OUTPUT.PUT_LINE`, umsebenzi osivumela ukuthi singene noma sikhiphe okufakiwe ngakunye.

'โ€ฆ' yisimeli somlayezo welogi. Noma yini oyibeka lapho izophuma kukhonsoli yakho, njengalokhu:

DBMS_OUTPUT.PUT_LINE('Loga lokhu ukuze uthole ukulungisa iphutha...');

Le khodi ye-Oracle SQL iqondisa isistimu ukuthi ibhale umlayezo 'Ukuloga lokhu ukuze kulungiswe iphutha...' kukhonsoli.

Isitatimende esithi `KUPHELA;` simane sibonisa ukuphela kwemiyalo yethu ye-PL/SQL.

Ukwengeza Imininingwane Eminye Ekungeneni Kwekhonsoli

Nakuba isixazululo esingenhla sinikeza indawo yokuqala enhle, singadayela ukusebenza kahle kwaso, sithwebule imininingwane eminingi ye-granular lapho kudingeka.

Memezela
v_my_variable VARCHAR2(100) := 'Imininingwane yelogi enemininingwane iza laphaโ€ฆ';
QALA
DBMS_OUTPUT.ENABLE;
DBMS_OUTPUT.PUT_LINE(v_my_variable);
Ukuphela;

Ezimweni lapho izingodo ezinemininingwane kungase kudingeke, ungaqalisa okuguquguqukayo, unikeze imininingwane yelogi enemininingwane kulokhu okuguquguqukayo, bese ufaka lokhu ukuze ududuze.

Okungenhla kuyindlela esebenzayo neqondile yokungena kwe-Oracle SQL ukuze iduduze. Ngokwazi kahle le ndlela, ukulandelela ukusebenza kwesistimu nokulungisa iphutha kuba lula kakhulu.

Amalabhulali Engeziwe Nezinsiza Zokungena Kwe-Oracle SQL

  • UTL_FILE: Ngenye iphakheji enikezwe i-Oracle engakhiqiza amafayela ohlangothini lweseva. Lokhu kungase futhi kusetshenziselwe ukulandelela noma ukugawula imithi, kodwa inikeza indlela yokulandelela enemininingwane eminingi.
  • Isigatshana somushwana AMAPHUTHA ELOGO: Lokhu kusebenza okwakhelwe ngaphakathi okufakwe nezitatimende ze-DML (FAKA, BUYEKEZA, SUSA, HLANGANISA) kuvumela ukubhala amaphutha enzeka ngesikhathi kusetshenziswa lezi zitatimende, ngisho noma izitatimende ziqeda ngempumelelo.

Lawa maphakheji awakuvumeli kuphela ukuthi wenze ukugawulwa kwemithi okuyisisekelo kodwa futhi nokungena kusengaphambili nokubika I-Oracle SQL.

Okuthunyelwe okuhlobene:

Shiya amazwana