dbms_lob.compare-String (matched)-CLOB compare » ORACLE

dbms_lob.compare-Stringvergleich (matched) » ORACLE


Australien - Perth - Impression #australien #perth #impression -------------------------------------------------------------- ctpm - Synergy von Business & Gesundheit #synergyvonbusinessundgesundheit #ctpmsynergyvonbusinessundgesundheit -------------------------------------------------------------- Business-Unit: CTPM - BUSINESS IT-Consulting - Development & Programming - Administration - Business Analysis - Solution Architectures - Testmanagement Management-Consulting - Career Planning - Start-up Coaching & Consulting - Freelancer Management - Recruitment Consultant - Backoffice - PMO Training & Development CTPM - HEALTH Health & Wellness - Burnout - Prevention - Education & Training - Coaching - Health-related Travel Massage & Workout Saltgrotto CTPM - ACCOMMODATION Bed & Breakfast Apartment Conference Room Meetingpoint CTPM - MOVE Corporate Sailing & Hiking - Coaching - Teambuilding & Events Boating School - Boating License - Skippertraining Rent a Skipper Guests Hiking Personal Training -------------------------------------------------------------- Tags #ctpm #ctpm-business #ctpmbusiness #business #it-consulting #itconsulting #it #consulting #development #programming #developmentandprogramming #developmentprogramming #oracle #plsql #oracledba #webdesign #wordpress #oracleadministration #businessanalysis #solutionarchitectures #testmanagement #testmanager #softwarearchitect #management #consulting #managementconsulting #careerplanning #start-upcoaching #start-up-coaching #startup-coaching #startupcoaching #start-upconsulting #start-up-consulting #startup-consulting #startupconsulting #freelancer #freelancermanagement #freelancer-management - #recruitment #consultant #recruitmentconsultant #backoffice #PMO #training #development #traininganddevelopment #trainingdevelopment #ctpm-health #ctpmhealth #health #health #wellness #healthwellness #burnout #Prevention #burnoutprevention #education #training #healthtraining #coaching #healthcoaching #healthrelatedtravel #massage #workout #healthmassage #healthworkout #saltgrotto #saltcave #salzgrotte #ctpm-accommodation #ctpmaccommodation #accommodation #bedandbreakfast #bedbreakfast #bed-breakfast #privatzimmer #gästezimme #hotelzimmer #monteurzimmer #messezimmer #messebetten #messeköln #messecologne #messedüsseldorf #übernachtung #unterkunft #schlafen #Apartment #appartment #ferienwohnung #conferenceroom #conference-room #meetingpoint #büro #büroaufzeit #office #ctpm-move #ctpmmove #move #corporatesailing #corporatehiking #corporate-sailing #corporate-hiking #corporate #sailing #corporate #hiking #movecoaching #teambuilding #teamevents #boating #boatingschool #boating-school #bootsschule #sportbootsschule #segelschule #boatinglicense #boating-license #boating #skippertraining #skipper #skippertrainer #rent-a-skipper #rentaskipper #guestshiking #personaltraining #personaltrainer #personal-training #personal-trainer -- #cologne #köln #koeln #berlin #lindlar #rheinland #germany #deutschland #nrw #europa #nordrhein-westfalen #nordrheinwestfalen #oberbergischerkreis #oberberg

Australien – Perth – Impression


ORACLE – Seminare, Schulungen, Kurse und Workshops

  • Professioneller Einstieg in Oracle SQL
  • Oracle PL/SQL und DB-Programmierung
  • Oracle SQL- / PL/SQL-Tuning
  • Datenmodellierung und Datenbankdesign
  • Oracle SQL für Umsteiger
  • Oracle Datenbankadministration DBA
  • Oracle Backup & Recovery
  • Oracle Forms-Developer / Oracle Developer Suite

ORACLE – Dozenten, Trainer und Coaches

  • Dozenten und Coaches

dbms_lob.compare-CLOB compare

Die DBMS_LOB.COMPARE-Funktion wird verwendet, um zwei LOB’s zu vergleichen, die vom gleichen Type sind. Es besteht auch die Möglichkeit nur einzelne Part’s vom LOB  abzugleichen. DBMS_LOB.INSTR kann hier behilflich sein die Einstiegsposition zu definieren. Hier ein Beispiel:

SAMPLE

--dbms_lob.compare - Stringvergleich (matched) - CLOB compare - Oracle

-- DDL - Create Table / Sequence
drop table TAB_check_clob;
create table TAB_check_clob (tcc_string_id number(16)
                            ,tcc_check_lfd varchar2(16)
                            ,tcc_string varchar2(4000)
                            ,tcc_value varchar2(4000)
                            ,tcc_vorkommnis number(3)
                            );
--
drop sequence SEQ_check_clob;
create sequence SEQ_check_clob
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1;
-- DML - Insert "ToCheck"-Values
insert into TAB_check_clob values (SEQ_check_clob.nextval,'1','<Firma>',' ctpm',1);

insert into TAB_check_clob values (SEQ_check_clob.nextval,'1','<Telefon>',' +49 (0)221 277446-45',1);
insert into TAB_check_clob values (SEQ_check_clob.nextval,'1','<Standort>',' Lindlar',1);
insert into TAB_check_clob values (SEQ_check_clob.nextval,'1','<Standort>',' Köln',2);
insert into TAB_check_clob values (SEQ_check_clob.nextval,'1','<Standort>',' Hamburg',3);
insert into TAB_check_clob values (SEQ_check_clob.nextval,'1','<Standort>',' Berlin',4);
commit;

-- PL/SQL - 
declare
   procedure check_clob (IN_check_lfd TAB_check_clob.tcc_check_lfd%type, IN_clob clob) as
   begin
     for rec in (select *
                   from tab_check_clob c
                  where c.tcc_check_lfd = IN_check_lfd)
     loop
       dbms_output.put_line('Test-: '||IN_check_lfd||
                            ' - ' ||rec.tcc_string||
                            ' - ' ||dbms_lob.compare( IN_clob
                                                     ,rec.tcc_value
                                                     ,length(rec.tcc_value)
                                                     , dbms_lob.instr(IN_clob
                                                                     ,rec.tcc_string
                                                                     ,1
                                                                     ,rec.tcc_vorkommnis
                                                                     )+length(rec.tcc_string)
                                                     )
                            );
     end loop;
   end;
begin
   dbms_output.enable(10000000);
   check_clob('1','<Firma> ctpm'||chr(10)||
                  '<Telefon> +49 (0)221 277446-45'||chr(10)||
                  '<Standort> Lindlar'||chr(10)||
                  '<Standort> Koeln'||chr(10)||
                  '<Standort> Hamburg'||chr(10)||
                  '<Standort> Berlin'
              );
end;

--Ausgabe:

/*
Test-: 1 - <Firma> - 0
Test-: 1 - <Telefon> - 0
Test-: 1 - <Standort> - 0
Test-: 1 - <Standort> - -1 -- Koeln vs. Köln
Test-: 1 - <Standort> - 0
Test-: 1 - <Standort> - 0
*/

Möchten Sie das auch einsetzen?! Worauf wartet Sie? Der Rest vom Leben beginnt JETZT!


TIPP


ctpm – Business
– Oracle Training & Development –
Frankenwerft 3
50667 Köln

+49 221 277446-45