. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 452 8.9.1. COALESCE() . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . | R | S | T | U | V | W | X | Y | Z ::= a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z Chapter 2. SQL Sprachstruktur Dateien können in einer ADD-Klausel hinzugefügt werden: ALTER DATABASE ADD FILE x LENGTH 8000 FILE y LENGTH 8000 FILE z Mehrfaches Vorkommen von add_sec_clause (ADD FILE-Klauseln) ist erlaubt; eine

2005 PV Added information on COALESCE Corrected some spelling errors 2005 PV Added information on COALESCE Corrected some spelling errors

@startuml :$int\_0^1f(x)dx$; :$x^2+y\_1+z\_12^34$; note right Try also $d/dxf(x)=lim\_(h->0)(f(x+h)-f(x))/h$ P(y|\mathbf{x}) \mbox{ or } f(\mathbf{x})+\epsilon !definelong and !enddefinelong. @startuml !define DOUBLE(x) x x !definelong AUTHEN(x,y) x -> y : DOUBLE(hello) y -> x : ok !enddefinelong AUTHEN(Bob,Alice) @enduml 17.8 Default values for macro parameters assign default values to macro parameters. @startuml !define some_macro(x, y = "some default" , z = 'another default' ) x and y and z class foo { some_macro(Z1, Z2, Z3) some_macro(Z1, Z2) some_macro(A)

@startuml :$int\_0^1f(x)dx$; :$x^2+y\_1+z\_12^34$; note right Try also $d/dxf(x)=lim\_(h->0)(f(x+h)-f(x))/h$ P(y|\mathbf{x}) \mbox{ or } f(\mathbf{x})+\epsilon !definelong and !enddefinelong. @startuml !define DOUBLE(x) x x !definelong AUTHEN(x,y) x -> y : DOUBLE(hello) y -> x : ok !enddefinelong AUTHEN(Bob,Alice) @enduml PlantUML Sprachreferenz (1.2019.4) assign default values to macro parameters. @startuml !define some_macro(x, y = "some default" , z = 'another default' ) x and y and z class foo { some_macro(Z1, Z2, Z3) some_macro(Z1, Z2) some_macro(A)

@startuml :$int\_0^1f(x)dx$; :$x^2+y\_1+z\_12^34$; note right Try also $d/dxf(x)=lim\_(h->0)(f(x+h)-f(x))/h$ P(y|\mathbf{x}) \mbox{ or } f(\mathbf{x})+\epsilon !definelong and !enddefinelong. @startuml !define DOUBLE(x) x x !definelong AUTHEN(x,y) x -> y : DOUBLE(hello) y -> x : ok !enddefinelong AUTHEN(Bob,Alice) @enduml PlantUML Sprachreferenz (1.2019.3) assign default values to macro parameters. @startuml !define some_macro(x, y = "some default" , z = 'another default' ) x and y and z class foo { some_macro(Z1, Z2, Z3) some_macro(Z1, Z2) some_macro(A)

@startuml :$int\_0^1f(x)dx$; :$x^2+y\_1+z\_12^34$; note right Try also $d/dxf(x)=lim\_(h->0)(f(x+h)-f(x))/h$ P(y|\mathbf{x}) \mbox{ or } f(\mathbf{x})+\epsilon !definelong and !enddefinelong. @startuml !define DOUBLE(x) x x !definelong AUTHEN(x,y) x -> y : DOUBLE(hello) y -> x : ok !enddefinelong AUTHEN(Bob,Alice) @enduml PlantUML Sprachreferenz (1.2019.2) assign default values to macro parameters. @startuml !define some_macro(x, y = "some default" , z = 'another default' ) x and y and z class foo { some_macro(Z1, Z2, Z3) some_macro(Z1, Z2) some_macro(A)

S1 -up[#red,dashed]-> S4 S1 -right[dotted,#blue]-> S5 X1 -[dashed]-> X2 Z1 -[dotted]-> Z2 Y1 -[#blue,bold]-> Y2 @enduml [Ref. Incubation: Change line color in state diagrams] 9.15 Notizen Notizen können Without style (by default) @startuml nwdiag { network DMZ { address = "y.x.x.x/24" web01 [address = "y.x.x.1"]; web02 [address = "y.x.x.2"]; } network Internal { web01; web02; db01 [address = "w.w.w.z" diagram (nwdiag) 13 NETWORK DIAGRAM (NWDIAG) network DMZ { address = "y.x.x.x/24" web01 [address = "y.x.x.1"]; web02 [address = "y.x.x.2"]; } network Internal { web01; web02; db01 [address = "w.w.w.z"

kfreebsd-i386 mips ←� mipsel powerpc s390 sparc Components: main contrib non-free Description: Debian x.y Unstable - Not Released MD5Sum: bdc8fa4b3f5e4a715dd0d56d176fc789 18876880 Contents-alpha.gz 9469a0 set backspace=indent,eol,start ” :h ’bs (default: nobs) -- sensible BS set statusline=%<%f%m%r%h%w%=%y[U+%04B]%2l/%2L=%P,%2c%V set listchars=eol:¶,tab:b’’￿b’’\ ,extends:b’’￿b’’,precedes:b’’￿b’’,nbsp:b’’￿b’’ mappings for Vim. See :h default-mappings in nvim ””” copy to EOL (no delete) like D for d noremap Y y$ ””” sets a new undo point before deleting inoremap u inoremap u ”””

S1 -up[#red,dashed]-> S4 S1 -right[dotted,#blue]-> S5 X1 -[dashed]-> X2 Z1 -[dotted]-> Z2 Y1 -[#blue,bold]-> Y2 @enduml [Ref. Incubation: Change line color in state diagrams] 7.15 Notizen Notizen können @startuml :$int\_0^1f(x)dx$; :$x^2+y\_1+z\_12^34$; note right Try also $d/dxf(x)=lim\_(h->0)(f(x+h)-f(x))/h$ P(y|\mathbf{x}) \mbox{ or } f(\mathbf{x})+\epsilon parameter list can have default values. @startuml !procedure defaulttest($x, $y="DefaultY", $z="DefaultZ") note over Alice x = $x y = $y z = $z end note !endprocedure defaulttest(1, 2, 3) defaulttest(1, 2) defaulttest(1)

S1 -up[#red,dashed]-> S4 S1 -right[dotted,#blue]-> S5 X1 -[dashed]-> X2 Z1 -[dotted]-> Z2 Y1 -[#blue,bold]-> Y2 @enduml [Ref. Incubation: Change line color in state diagrams] 7.15 Notizen Notizen können @startuml :$int\_0^1f(x)dx$; :$x^2+y\_1+z\_12^34$; note right Try also $d/dxf(x)=lim\_(h->0)(f(x+h)-f(x))/h$ P(y|\mathbf{x}) \mbox{ or } f(\mathbf{x})+\epsilon parameter list can have default values. @startuml !procedure defaulttest($x, $y="DefaultY", $z="DefaultZ") note over Alice x = $x y = $y z = $z end note !endprocedure defaulttest(1, 2, 3) defaulttest(1, 2) defaulttest(1)