dynamic&automatic INSERT Statement Generator-SQL/DML/ORACLE

ORACLE External Table – DYNAMIC ACCESS GENERATOR


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

Dynamischer und automatischer GENERATOR für INSERT-Befehle SQL / DML / ORACLE

declare

  v_oldtab   varchar2(30)  := null;

  v_template clob          := 'insert into <#2> (<#1>) (select <#3> from source_<#4>)';

  v_sql      clob          := v_template;

  v_col      clob;

begin

  -- TABLE-LIST  -  DATA DICTIONARY - 'COL'

  for rec in (select tname, cname

                from col

               where 1=1

                 and colno not in (1)  -- FIRST COL ELEIMINATE

                 and tname

                  in ('USER_TAB1'

                     ,'USER_TAB2'

            order by tname, colno)

  loop

    if v_oldtab is null or rec.tname <> v_oldtab then

       -- CREATE INSERT DML

       if rec.tname <> v_oldtab then

          v_sql := replace(v_sql,'<#1>',v_col);

          v_sql := replace(v_sql,'<#3>',v_col);

          dbms_output.put_line(v_sql);

       end if;

       v_sql := v_template;

       v_sql := replace(v_sql,'<#2>',rec.tname);

       v_sql := replace(v_sql,'<#4>',rec.tname);

       v_oldtab := rec.tname;

       v_col    := rec.cname;

    else

       -- CREATE COL-LIST

       v_col := v_col||' ,'||rec.cname;

    end if;  

  end loop;            

end;

SAMPLE

insert into USER_TAB1 (ID ,FIELD1,FIELD2) (select ID ,FIELD1,FIELD2 from source_USER_TAB1)

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