CASE expressions in the ORDER BY clause – ORACLE

ORACLE – CASE expressions in the ORDER BY clause


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


CASE expressions in the ORDER BY clause – ORACLE

YES IT CAN …  !!!

Die Funktionalität von CASE kann auch beim ORDER BY eingesetzt werden. Beim SELECT auf die Dataditionary View: COL werden mittels CASE Gruppen je Datentyp gebildet. Diese stellen das erste Sortierkriterium dar, gefolgt von TNAME (Tabellenname) und COLNO (Spaltennummer).

SAMPLE

–CASE expressions in the ORDER BY clause

select *
from col c
order by case when coltype = 'DATE' or coltype like 'TIME%' then 1 -- Groupe I
when coltype = 'VARCHAR2' or coltype = 'CHAR' then 2 -- Groupe II
when coltype = 'NUMBER' then 3 -- Groupe III
when coltype like '%LOB' then 4 -- Groupe IV
else 5 -- Groupe V
end desc
,tname asc
,colno asc;

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