{"id":3256,"date":"2022-03-15T15:20:56","date_gmt":"2022-03-15T14:20:56","guid":{"rendered":"https:\/\/adm-adria.si\/?p=3256"},"modified":"2022-03-15T15:20:57","modified_gmt":"2022-03-15T14:20:57","slug":"13-funkcij-v-toad-za-oracle-za-katere-morda-niste-vedeli","status":"publish","type":"post","link":"https:\/\/adm-adria.si\/en\/2022\/03\/13-funkcij-v-toad-za-oracle-za-katere-morda-niste-vedeli\/","title":{"rendered":"13 funkcij v Toad\u00ae za Oracle za katere morda niste vedeli"},"content":{"rendered":"<p>Popularno orodje Toad za Oracle je \u017ee nekaj \u010dasa na voljo v novi verziji 13.2. \u010ce \u0161e niste preverili vseh funkcionalnosti, si o njih lahko preberete v nadaljevanju.<\/p>\n\n\n\n<p>Pri upravljanju podatkov in podatkovnih baz se sre\u010dujemo s \u0161tevilnimi te\u017eavami, ki ote\u017eujejo delovne procese in lahko v najslab\u0161em primeru vplivajo tudi na poslovanje. Zato smo se dotaknili&nbsp; 13 funkcij, ki so dodane &nbsp;v orodje \u00bbToad for Oracle\u00ab, in olaj\u0161ujejo upravljanje podatkov in podatkovnih baz.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1. Novo na\u010din testiranja, zgrajen na utPLSQL<\/h3>\n\n\n\n<p>Grafi\u010dni vmesnik za priljubljeno odprtokodno re\u0161itev za testiranje utPLSQL. Ustvarite in za\u017eenite teste ter preverite rezultate testov.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"691\" src=\"https:\/\/adm-adria.si\/wp-content\/uploads\/2022\/03\/1_utplsql-1024x691.jpg\" alt=\"\" class=\"wp-image-3258\" srcset=\"https:\/\/adm-adria.si\/wp-content\/uploads\/2022\/03\/1_utplsql-1024x691.jpg 1024w, https:\/\/adm-adria.si\/wp-content\/uploads\/2022\/03\/1_utplsql-300x203.jpg 300w, https:\/\/adm-adria.si\/wp-content\/uploads\/2022\/03\/1_utplsql-768x519.jpg 768w, https:\/\/adm-adria.si\/wp-content\/uploads\/2022\/03\/1_utplsql.jpg 1241w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">2. Za\u0161\u010dita ob\u010dutljivih podatkov<\/h3>\n\n\n\n<p>Zdaj lahko definirate pravila za nadzor dostopa (\u00bbaudit\u00ab), \u0161ifriranje in mo\u017enosti redakcijskih politik, prav tako kot po meri dolo\u010dene kategorije pomembnosti (dolo\u010dene s strani uporabnika), kot posamezna pravila za ob\u010dutljive podatke. Pravila &nbsp;se pravilniki lahko uporabijo za skupino stolpcev, tako da izberete \u017eeljene stolpce in izberete \u2018\u2019Apply Default Policies\u2019\u2019. To vam omogo\u010da, da nastavite pravilnike za ve\u010d stolpcev hkrati in ne posamezno.<\/p>\n\n\n\n<p><em>Main Menu: View -> Toad Options -> Sensitive Dat<\/em><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"871\" height=\"621\" src=\"https:\/\/adm-adria.si\/wp-content\/uploads\/2022\/03\/2_sdp_options.jpg\" alt=\"\" class=\"wp-image-3259\" srcset=\"https:\/\/adm-adria.si\/wp-content\/uploads\/2022\/03\/2_sdp_options.jpg 871w, https:\/\/adm-adria.si\/wp-content\/uploads\/2022\/03\/2_sdp_options-300x214.jpg 300w, https:\/\/adm-adria.si\/wp-content\/uploads\/2022\/03\/2_sdp_options-768x548.jpg 768w\" sizes=\"auto, (max-width: 871px) 100vw, 871px\" \/><\/figure>\n\n\n\n<p><em>Main Menu: Database -> Report -> Sensitive Data Protection Search<\/em><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"891\" height=\"601\" src=\"https:\/\/adm-adria.si\/wp-content\/uploads\/2022\/03\/3_sdp.jpg\" alt=\"\" class=\"wp-image-3260\" srcset=\"https:\/\/adm-adria.si\/wp-content\/uploads\/2022\/03\/3_sdp.jpg 891w, https:\/\/adm-adria.si\/wp-content\/uploads\/2022\/03\/3_sdp-300x202.jpg 300w, https:\/\/adm-adria.si\/wp-content\/uploads\/2022\/03\/3_sdp-768x518.jpg 768w\" sizes=\"auto, (max-width: 891px) 100vw, 891px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">3. Posodobljena funkcija Ustvari\/Spremeni okna DB<\/h3>\n\n\n\n<p>Ta okna imajo posodobljen videz. Tukaj je posnetek zaslona novega okna Alter Table (obstaja pa \u0161e pribli\u017eno 40 drugih!)<\/p>\n\n\n\n<p>Mai<em>n Menu: Database -> Create -> Table<\/em><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"771\" height=\"602\" src=\"https:\/\/adm-adria.si\/wp-content\/uploads\/2022\/03\/4_CreateAlterTable.jpg\" alt=\"\" class=\"wp-image-3261\" srcset=\"https:\/\/adm-adria.si\/wp-content\/uploads\/2022\/03\/4_CreateAlterTable.jpg 771w, https:\/\/adm-adria.si\/wp-content\/uploads\/2022\/03\/4_CreateAlterTable-300x234.jpg 300w, https:\/\/adm-adria.si\/wp-content\/uploads\/2022\/03\/4_CreateAlterTable-768x600.jpg 768w\" sizes=\"auto, (max-width: 771px) 100vw, 771px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">4. Posodobljeno okno Analyze Objects<\/h3>\n\n\n\n<p>Fuknkcija \u00bbAnalyze Objects\u00ab ima nov potek dela, ki je enostaven za uporabo, in je zdaj podprt v \u00bbAutomation designerju\u00ab.<\/p>\n\n\n\n<p>Main Men<em>u: Database -> Optimize -> Analyze Objects<\/em><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"755\" height=\"525\" src=\"https:\/\/adm-adria.si\/wp-content\/uploads\/2022\/03\/5_Analyze.jpg\" alt=\"\" class=\"wp-image-3262\" srcset=\"https:\/\/adm-adria.si\/wp-content\/uploads\/2022\/03\/5_Analyze.jpg 755w, https:\/\/adm-adria.si\/wp-content\/uploads\/2022\/03\/5_Analyze-300x209.jpg 300w\" sizes=\"auto, (max-width: 755px) 100vw, 755px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">5. Izvoz\/uvoz povezav<\/h3>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"5\" height=\"6\" src=\"\">\u00a0&#8211; Zdaj vklju\u010duje geslo (za\u0161\u010diteno z glavnim geslom)<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">6. Podpora\/skladnost<\/h3>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"5\" height=\"39\" src=\"\">&#8211; Podpora za Windows 10<br>&#8211; Podpora za Oracle 19c<br>&#8211; \u00a0skladnost s standardom FIPS<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">7. XMLType<\/h3>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"5\" height=\"6\" src=\"\">&#8211; Ni ve\u010d potrebno ro\u010dno vklju\u010diti .GetCLOBVal() v va\u0161e poizvedbe z XMLTYPE. To se zdaj zgodi samodejno v zakulisju.<br>&#8211; Podatke XMLTYPE je zdaj mogo\u010de urejati v urejevalniku v pojavnem oknu (samo vklju\u010dite ROWID v svoj query).<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">8. Okno za primerjavo podatkov<\/h3>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"5\" height=\"40\" src=\"\">&#8211; Podpira BLOB, CLOB, NCLOB, XMLTYPE.<br>&#8211; Mo\u017enost ustvarjanja poro\u010dila o razlikah ( tudi v funkciji Compare Multiple Tables).<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3. Izvoz nabora podatkov<\/h3>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"5\" height=\"6\" src=\"\">&#8211; Zdaj \u0161e hitrej\u0161i!<br>&#8211; Omogo\u010dite\/onemogo\u010dite samodejno poimenovanje datoteke (na podlagi izvo\u017eene tabele) z desnim klikom na polje \u2018\u2019filename\u2019\u2019.<br>&#8211; Lahko se dolo\u010di kriterij za tabele, ki se izva\u017eajo.<img loading=\"lazy\" decoding=\"async\" width=\"5\" height=\"6\" src=\"\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">10. Skupinsko pisanje kode<\/h3>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"5\" height=\"6\" src=\"\">&#8211; Vse nastavitve VCS in Team Coding je zdaj mogo\u010de varnostno kopirati ali z novimi gumbi na orodni vrstici v oknu \u2018\u2019Team Coding Configuration\u2019\u2019.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">11. Analiza kode<\/h3>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"5\" height=\"6\" src=\"\">\u00a0&#8211; ve\u010d novih in posodobljenih pravil analize.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">12. Za\u0161\u010dita ob\u010dutljivih podatkov<\/h3>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"5\" height=\"6\" src=\"\">&#8211; Dodana pravila regularnih izrazov za obi\u010dajna identifikacijska imena in oblike, ki se uporabljajo po vsej Evropski uniji.<br>&#8211; V okno s pravili je bilo dodano polje &#8220;examples&#8221; in gumb &#8220;test&#8221;, tako da lahko pravila preizku\u0161ate med tem, ko jih dodajate.<br>&#8211; V okno s pravili je bilo dodano polje &#8220;examples&#8221; in gumb &#8220;test&#8221;, tako da lahko pravila preizku\u0161ate med tem, ko jih dodajate.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">13. Oblikovalec avtomatizacije\/razporejevalnik opravil<\/h3>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"5\" height=\"6\" src=\"\">&#8211; Nova, enostavna migracija na\u010drtovanih \u00bbToad actions\u00ab iz prej\u0161nje razli\u010dice Toad na razli\u010dico 13.2.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p><strong>\u017delite ve\u010d informacij o re\u0161itvi TOAD?<\/strong><\/p><p>Sporo\u010dite svojo \u017eeljo na\u00a0<a href=\"mailto:info@adm-adria.eu\">info@adm-adria.eu<\/a>\u00a0ali telefon 059 251 955 in z veseljem vam bomo pomagali in svetovali.<\/p><p>V podjetju ADM-Adria smo Platinum+ partner proizvajalca re\u0161itev Quest.<\/p><\/blockquote>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/sp-ao.shortpixel.ai\/client\/to_auto,q_glossy,ret_img,w_261,h_107\/https:\/\/adm-adria.si\/wp-content\/uploads\/2021\/09\/Quest-Platinum-Plus-Partner-ADM-Adria.webp\" alt=\"Ta slika ima prazen atribut alt; ime datoteke je Quest-Platinum-Plus-Partner-ADM-Adria.webp\"\/><\/figure>","protected":false},"excerpt":{"rendered":"<p>Popularno orodje Toad za Oracle je \u017ee nekaj \u010dasa na voljo v novi verziji 13.2. \u010ce \u0161e niste preverili vseh funkcionalnosti, si o njih lahko preberete v nadaljevanju. Pri upravljanju podatkov in podatkovnih baz se sre\u010dujemo s \u0161tevilnimi te\u017eavami, ki ote\u017eujejo delovne procese in lahko v najslab\u0161em primeru vplivajo tudi na poslovanje. Zato smo se [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":3263,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-3256","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-novice"],"_links":{"self":[{"href":"https:\/\/adm-adria.si\/en\/wp-json\/wp\/v2\/posts\/3256","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/adm-adria.si\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adm-adria.si\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adm-adria.si\/en\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/adm-adria.si\/en\/wp-json\/wp\/v2\/comments?post=3256"}],"version-history":[{"count":1,"href":"https:\/\/adm-adria.si\/en\/wp-json\/wp\/v2\/posts\/3256\/revisions"}],"predecessor-version":[{"id":3264,"href":"https:\/\/adm-adria.si\/en\/wp-json\/wp\/v2\/posts\/3256\/revisions\/3264"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/adm-adria.si\/en\/wp-json\/wp\/v2\/media\/3263"}],"wp:attachment":[{"href":"https:\/\/adm-adria.si\/en\/wp-json\/wp\/v2\/media?parent=3256"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adm-adria.si\/en\/wp-json\/wp\/v2\/categories?post=3256"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adm-adria.si\/en\/wp-json\/wp\/v2\/tags?post=3256"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}