Skip to Main Content

Multiple

previous line, rotate colors

  • 3A07E75935C40F59E0630311A8C0B1DC-1
  • 3A07E75935C50F59E0630311A8C0B1DC-0
  • 3A07E75935C60F59E0630311A8C0B1DC-1
  • 3A07E75935C70F59E0630311A8C0B1DC-0
  • 3A07E75935C80F59E0630311A8C0B1DC-1
  • 3A07E75935C90F59E0630311A8C0B1DC-0
  • 3A07E75935CA0F59E0630311A8C0B1DC-1
  • 3A07E75935CB0F59E0630311A8C0B1DC-0
  • 3A07E75935CC0F59E0630311A8C0B1DC-1
  • 3A07E75935CD0F59E0630311A8C0B1DC-0
  • 3A07E75935CE0F59E0630311A8C0B1DC-1
  • 3A07E75935CF0F59E0630311A8C0B1DC-0
  • 3A07E75935D00F59E0630311A8C0B1DC-1
  • 3A07E75935D10F59E0630311A8C0B1DC-0
  • 3A07E75935D20F59E0630311A8C0B1DC-1
  • first line, rotate colors

  • 3A07E75935D30F59E0630311A8C0B1DC-1
  • 3A07E75935D40F59E0630311A8C0B1DC-0
  • 3A07E75935D50F59E0630311A8C0B1DC-1
  • 3A07E75935D60F59E0630311A8C0B1DC-0
  • 3A07E75935D70F59E0630311A8C0B1DC-1
  • 3A07E75935D80F59E0630311A8C0B1DC-0
  • 3A07E75935D90F59E0630311A8C0B1DC-1
  • 3A07E75935DA0F59E0630311A8C0B1DC-0
  • 3A07E75935DB0F59E0630311A8C0B1DC-1
  • 3A07E75935DC0F59E0630311A8C0B1DC-0
  • 3A07E75935DD0F59E0630311A8C0B1DC-1
  • 3A07E75935DE0F59E0630311A8C0B1DC-0
  • 3A07E75935DF0F59E0630311A8C0B1DC-1
  • 3A07E75935E00F59E0630311A8C0B1DC-0
  • 3A07E75935E10F59E0630311A8C0B1DC-1
  • previous line, rotating colors off

  • 3A07E75935E20F59E0630311A8C0B1DC-1
  • 3A07E75935E30F59E0630311A8C0B1DC-0
  • 3A07E75935E40F59E0630311A8C0B1DC-1
  • 3A07E75935E50F59E0630311A8C0B1DC-0
  • 3A07E75935E60F59E0630311A8C0B1DC-1
  • 3A07E75935E70F59E0630311A8C0B1DC-0
  • 3A07E75935E80F59E0630311A8C0B1DC-1
  • 3A07E75935E90F59E0630311A8C0B1DC-0
  • 3A07E75935EA0F59E0630311A8C0B1DC-1
  • 3A07E75935EB0F59E0630311A8C0B1DC-0
  • 3A07E75935EC0F59E0630311A8C0B1DC-1
  • 3A07E75935ED0F59E0630311A8C0B1DC-0
  • 3A07E75935EE0F59E0630311A8C0B1DC-1
  • 3A07E75935EF0F59E0630311A8C0B1DC-0
  • 3A07E75935F00F59E0630311A8C0B1DC-1
  • previous line, rotating colors, separator "-"

  • 3A07E75935F10F59E0630311A8C0B1DC-1
  • 3A07E75935F20F59E0630311A8C0B1DC-0
  • 3A07E75935F30F59E0630311A8C0B1DC-1
  • 3A07E75935F40F59E0630311A8C0B1DC-0
  • 3A07E75935F50F59E0630311A8C0B1DC-1
  • 3A07E75935F60F59E0630311A8C0B1DC-0
  • 3A07E75935F70F59E0630311A8C0B1DC-1
  • 3A07E75935F80F59E0630311A8C0B1DC-0
  • 3A07E75935F90F59E0630311A8C0B1DC-1
  • 3A07E75935FA0F59E0630311A8C0B1DC-0
  • 3A07E75935FB0F59E0630311A8C0B1DC-1
  • 3A07E75935FC0F59E0630311A8C0B1DC-0
  • 3A07E75935FD0F59E0630311A8C0B1DC-1
  • 3A07E75935FE0F59E0630311A8C0B1DC-0
  • 3A07E75935FF0F59E0630311A8C0B1DC-1
  • diff mode chars

  • Hello my dear friend
  • Hello my favorite friend
  • Hello my dear friend
  • Hello my dear friend
  • Hello my super nice friend
  • diff mode words

  • Hello my dear friend
  • Hello my favorite friend
  • Hello my dear friend
  • Hello my dear friend
  • Hello my super nice friend
  • Query:
    select sys_guid() || '-' || mod(rownum, 2) as text
      from dual
      connect by rownum <= 15
    
    select 'Hello my dear friend' as str from dual
    union all
    select 'Hello my favorite friend' as str from dual
    union all
    select 'Hello my dear friend' as str from dual
    union all
    select 'Hello my dear friend' as str from dual
    union all
    select 'Hello my super nice friend' as str from dual
    

    Partial

    previous line, rotate colors, separator = ":"

    JobManagers
    ANALYST 1-7788-JONES:0-7902-JONES
    CLERK 1-7900-BLAKE:0-7934-CLARK:0-7369-FORD
    MANAGER 1-7698-KING:0-7782-KING:1-7566-KING
    SALESMAN 1-7654-BLAKE:0-7521-BLAKE:1-7499-BLAKE:0-7844-BLAKE
    • 1 - 4

    first line, rotate colors, separator = ":"

    JobManagers
    ANALYST 1-7788-JONES:0-7902-JONES
    CLERK 1-7900-BLAKE:0-7934-CLARK:0-7369-FORD
    MANAGER 1-7698-KING:0-7782-KING:1-7566-KING
    SALESMAN 1-7654-BLAKE:0-7521-BLAKE:1-7499-BLAKE:0-7844-BLAKE
    • 1 - 4

    previous line, rotate colors off, separator = ":", diff mode="chars"

    JobManagers
    ANALYST 1-7788-JONES:0-7902-JONES
    CLERK 1-7900-BLAKE:0-7934-CLARK:0-7369-FORD
    MANAGER 1-7698-KING:0-7782-KING:1-7566-KING
    SALESMAN 1-7654-BLAKE:0-7521-BLAKE:1-7499-BLAKE:0-7844-BLAKE
    • 1 - 4

    previous line, rotate colors on, separator = ":", diff mode="words"

    JobManagers
    ANALYST 1-7788-JONES:0-7902-JONES
    CLERK 1-7900-BLAKE:0-7934-CLARK:0-7369-FORD
    MANAGER 1-7698-KING:0-7782-KING:1-7566-KING
    SALESMAN 1-7654-BLAKE:0-7521-BLAKE:1-7499-BLAKE:0-7844-BLAKE
    • 1 - 4
    Query:
    select e.job, listagg(mod(rownum, 2) || '-' || e.empno || '-' || mgr.ename  , ':') managers
      from emp e 
      join emp mgr on e.mgr = mgr.empno
     group by e.job