I-Oracle SQL inikeza uxhaxha olubanzi lwemisebenzi eyenza ukuphatha imininingwane yolwazi kube lula. Umsebenzi owodwa ovamile wabathuthukisi besizindalwazi ukuthola amagama ekholomu ethebula. Lokhu kungaba usizo ikakhulukazi ezimeni eziningi ezifana nokuhlola idatha, ukulungisa amaphutha, ukudala imibuzo eguquguqukayo ye-SQL, phakathi kokunye.
Ku-Oracle SQL, kunendlela ephumelela kakhulu yokuthola amagama ekholomu yetafula. Lokhu kubandakanya ukubuza isichazamazwi sedatha, okuyisethi yamathebula nokubukwa okuqukethe imethadatha emayelana nesizindalwazi ngokwaso.
KHETHA igama_lekholomu
KUSUKA kuwo wonke_amakholomu_amathebhu
LAPHO table_name = 'igama_letafula_lakho';
Ngokumane umiselele 'igama_letafula_lakho' ufake igama elithile lethebula lakho, lo mbuzo uzobuyisela uhlu lwamagama ekholomu kulelo thebula.
Ukuqonda Ikhodi
Nansi incazelo yesinyathelo ngesinyathelo yombuzo ongenhla. I-Oracle SQL iqukethe ithebula elinegama elithi all_tab_columns eligcina ulwazi lwawo wonke amakholomu kusizindalwazi. Lolu lwazi luhlanganisa amagama amakholomu, amagama ethebula, izinhlobo zedatha, ubude, neminye imininingwane efanele.
Umyalo othi KHETHA usetshenziselwa ukukhetha idatha esifuna ukuyithola kusizindalwazi- kulesi simo, i-colum_name. Isigatshana esithi FROM sibonisa ithebula esikhipha idatha kulo, okuyi- all_tab_columns.
Isigatshana esithi LAPHO sisetshenziselwa ukucacisa imibandela okufanele kuhlangatshezwane nayo. Lapha, sinentshisekelo kuphela kumakholomu ethebula elithile, ngakho-ke sibeka ithebula_name = 'igama_letafula_lakho'. Lokhu kuhlunga imiphumela ukuze kubonise kuphela amagama ekholomu asuka kuthebula elibonisiwe.
Eminye Imisebenzi Efanelekile ye-Oracle SQL
Ukuqonda eminye imisebenzi eyakhelwe ngaphakathi ye-Oracle SQL esebenzisana namakholomu ethebula kungase kunikeze ulwazi olujulile ekuphatheni amakholomu ngamandla. Ake sibone ezimbalwa zazo:
- CHAZA: Lo myalo unikeza ukubuka konke okusheshayo kwesakhiwo sethebula, okubonisa amagama ekholomu, uhlobo lwedatha yekholomu ngayinye, nokuthi amanani angenalutho angagcinwa yini kukholamu.
- DBMS_METADATA.GET_DDL: Umsebenzi we-GET_DDL ubuyisela Ulimi Lwencazelo Yedatha (DDL) yento njengesethi yezitatimende ze-SQL. Lokhu kungase kuhlanganise noma yiziphi izinguquko zekholomu, njengokwengeza noma ukuwisa amakholomu.
Ngakho-ke, ukuqonda lokhu kusebenza kukunikeza umkhawulo ekubhekaneni nokukhohlisa kwetafula ku-Oracle SQL. Ngamandla okubuyisa amagama ekholomu yethebula, ukuhlomele ukuphatha imibuzo eguquguqukayo kanye nemisebenzi yokuhlola isizindalwazi ngendlela ephumelela kakhulu.
