MEMBER OF statt IN » ARRAY check » ORACLE

MEMBER OF – Inhalt eines ARRAY’s prüfen – 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


MEMBER OF eine Alternative für IN – ORACLE

Der „MEMBER OF“ (Mitglied sein) Operator wird in Oracle 10g PLSQL verwendet, um zu bestimmen, ob eine einzelne Variable in einer NESTED TABLE enthalten ist. Somit bietet „MEMBER OF“ eine Alternative zu der IN-Bedingung im Standard-SQL und bietet zudem an, dynamische Array’s zu überprüfen.

SAMPLE

-- TYPE drop
  drop type t_inlist;
-- TYPE create
  create type t_inlist is table of varchar2(32000);

-- Sample
  declare
   g_table t_inlist := t_inlist
   (
     'CTPM'
    ,'CTPM.DE'
    ,'CTPM-BUSINESS'
    ,'CTPM-HEALTH'
    ,'CTPM-ACCOMMODATION'
    ,'CTPM-MOVE'
    ,'CTPM-CORPORATESAILING'
    ,'DUAL'
   );
   v_tab varchar2(30);

  begin
-- enable OUTPUT
   dbms_output.enable(1000000);

-- Result: TRUE
   if 'CTPM-HEALTH' member of (g_table) then
     dbms_output.put_line('TRUE');
   else
     dbms_output.put_line('FALSE');
   end if;
-- Result: FALSE
   if 'XYZ' member of (g_table) then
     dbms_output.put_line('TRUE');
   else
     dbms_output.put_line('FALSE');
   end if;
-- Result: DUAL
  for rec in ( select a.table_name from all_tables a where a.table_name member of (g_table))
  loop
    dbms_output.put_line(rec.table_name);
  end loop;
  --
end;

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