Customer Directory in SQL

xxx xxxxxx xxxxxxxx xxxx xxxxx x xxx-xxxx xxxxxxxxx: xxxxx xxxxxxxx'x xxxx xxxx, xxxxxxx xxx xxxxx xxxxxx. xxx xxxx xxxx xx xxxx xxxxxx, xxx x xxxxxxxx xxx xxxx xxxxxxx xxxxxxxxx, xxxxxxx xxxxxx, xx xxxx xx xxxxxx.

xxxx_xxxxxxxxx(xxxxxxxxx, xxxxxxxxx, xxxxxxxx_xxxxxxxxx, xxxxxx) xx xxxxxxx xxxxxxx. xx xxxxxx xx xx-xxxxxx xxxxxx xxxxxxxx xxxx xxxxx xxxxxx:

xxxxxx xxxxx xxxxxxxx (
    xxxxxxxx_xx xxxxxxx xxxxxxx xxx,
    xxxxx       xxxx,              -- 'xx', 'xx', xxxx xx ''
    xxxxx_xxxx  xxxx xxx xxxx,
    xxxx_xxxx   xxxx xxx xxxx,
    xxxxxx      xxxx,              -- 'xx', 'xxx', xxxx xx ''
    xxxxxxxx    xxxx
);
xxxxxx xxxxx xxxxxxxx_xxxxxxx (
    xxxxxxxx_xxxxxxx_xx xxxxxxx xxxxxxx xxx,
    xxxxxxx_xxxx   xxxx,
    xx_xxxxxxx     xxxxxxx xxx xxxx,  -- x xx x
    xxxx_x xxxx, xxxx_x xxxx, xxxx xxxx, xxxxx_xxxxxxxx xxxx,
    xxxxxxx        xxxx xxx xxxx,
    xxxxxx_xxxx    xxxx
);
xxxxxx xxxxx xxxxxxxx_xxxxxxx (    -- xxxxx xxxxxxxxx xx xxxxxxxxx
    xxxxxxxx_xxxxxxx_xx xxxxxxx xxxxxxx xxx,
    xxxxxxxx_xx         xxxxxxx xxx xxxx,
    xxxxxxxx_xxxxxxx_xx xxxxxxx xxx xxxx
);
xxxxxx xxxxx xxxxx_xxxxxx (
    xxxxx_xxxxxx_xx    xxxxxxx xxxxxxx xxx,
    xxxxxxxx_xx        xxxxxxx xxx xxxx,
    xxxxx_xxxx         xxxx,
    xx_xxxxxxx         xxxxxxx xxx xxxx,  -- x xx x
    xxx_xxxxxxx_xxxx   xxxx,
    xxxxx_xxxxxxx_xxxx xxxx xxx xxxx,     -- 'x', 'xx', 'xx'
    xxxxx_xxxx_xxxx    xxxx xxx xxxx,
    xxxxx_xxxxxx       xxxx xxx xxxx      -- xxx xxxxx xxxxxx, xxxxxx xxxx
);

xxxxx xxx xxxxx xx xxxxxxxx_xxxxxxxxx(xxxx). xxxxxx xxx xxx (xxxx_xxxx, xxxxxxx, xxxxx) xxx xxxxx xxxxxxxx:

• xxxx_xxxx: xxx xxxxx, xxx xxxxx xxxx, xxx xxxx xxxx, xxx xxx xxxxxx xx xxxxxxxxxxx, xxxxxxxxx xx xxxxxx xxxxxx. xxxxx xxx x xxxxx xx x xxxxxx xxxx xx xxxx xx xxx xxxxx xxxxxx. xx xx xxxxx xxxxxxxxxxxx (xxx), xxxxx xxxxxx (xx), xx xxxx xxxxx, xxxx xxxxxx.
• xxxxxxx: xxx xxxxxxx xx xxx xxxxxxxx'x xxxxxxx. xxxxxxx xxxxxxxxx: xxxx x xxxxxxx xxx (xx_xxxxxxx = x) xxxx xxx xxxx xx xxx, xxxx xxx xxxxxxxx xxxxxxxx_xxxxxxx_xx. xx xxxxxxx: xxxx.
• xxxxx: xxxxx_xxxxxxx_xxxx-xxxxx_xxxx_xxxx-xxxxx_xxxxxx xxxx xxx xxxxxxxx'x xxxxx, xxx xxxxxxx x-xxx-xxxxxxx. xxxxxxx xxxxxx: xxxx x xxxxxxx xxx xxxx xxx xxxx xx xxx, xxxx xxx xxxxxxxx xxxxx_xxxxxx_xx. xx xxxxx: xxxx.

xxx xxxxxxx xxxxx xxxx xxx xxxxxxx, xxxxx xxxx xxx xxxxx: x xxxxxxxx xx xxx xxx xxx xxxx x +xx xxxxx.

xxxxx xxx xxxx xx xxxxx xxxx, xx xxxx xxxxx:

x. xxxxxxx. x. xxx xxxxx_xxxxxx xxxxxx xx xxx xxxxxx xxxxx: xxx xxxxx xxxxxx xx xxx xxx, xxxxxxxx xx xxxx. xx xxx xxxx xx xxx xxxxxxxxx xxxxx xxxxxx. x-xxx-xxxxxxx xxxxx xxxxxx x-xxx-xxxxxxx, xxxxxxx xxx xxxxx xxxxxx xxxxxxx xx xxxx xxxx xxxxxxx. xxxxxxxx xx xxxx, 'xxxxxxx' xxxxx xxxxxx 'xxxxxx'. x. xxxxxxxx_xx.

x xxxxxxx xxxxxxx xx x xxxxxxx xxxxx xxxxx xxxxx xxxxx xxxxxxx xxx. xxx xxxxxxxx xxxxxx xxxxx xx xxxx.

xxxxxxxx

xxxxxxxx_xxxxxxxxx(xxxx_xxxxxxxxx(
    [(x, "xx", "xxxxx", "xxxxxxxxxxxx", "xxx", "x"),
     (x, xxxx, "xxxxx", "xxxxxx", "xx", "x"),
     (x, "xx", "xxxx", "xxxxx", xxxx, "x"),
     (x, xxxx, "xxx", "xxx", xxxx, "x"),
     (x, "", "xxxx", "xxxxxx", "", "x")],
    [(x, "xxxx", x, "x xxxx xx", xxxx, "xxxx", xxxx, "xxx", "xxxxx"),
     (x, "xxxx", x, "x xxxx xx", xxxx, "xxxx", xxxx, "xxx", "xxxxx"),
     (x, "xxxx", x, "x xxxx xx", xxxx, "xxxx", xxxx, "xxx", "xxxxx"),
     (x, "xxxx", x, "x xxxx xx", xxxx, "xxxx", xxxx, "xxxxxxx", "xxxxx")],
    [(x, x, x), (x, x, x), (x, x, x), (x, x, x)],
    [(x, x, "xxxxxx", x, "xx", "xx", "xx", "xxxxxxx"),
     (x, x, "xxxxxx", x, "xx", "x", "xxx", "xxxxxxx"),
     (x, x, "xxxxxx", x, "xx", "x", "xxx", "xxxxxxx"),
     (x, x, "xxxxxx", x, "xx", "xx", "x", "xxxxxxxx")],
))
# [('xxxx xxxxxx', 'xxxxxxx', xxxx),
#  ('xx xxxxx xxxxxxxxxxxx (xxx)', 'xxx', 'xx-xx-xxxxxxx'),
#  ('xxxxx xxxxxx (xx)', 'xxx', 'x-xxx-xxxxxxx'),
#  ('xx xxxx xxxxx', 'xxx', 'x-xxx-xxxxxxx'),
#  ('xxx xxx', xxxx, 'xx-x-xxxxxxxx')]

xxxxxx xxx xxx xxx xxxxx xxxxxxx xxx xxxxx xxxxxxx xxxxxxx, xxxxxxx xxx xxxxxxx, xx x-xxx-xxxxxxx xxxxx xxxxxx x-xxx-xxxxxxx. xxx xxx xx xxxxxxx, xx xx xxxxx xxxx.

xxxxxxxx_xxxxxxxxx(xxxx_xxxxxxxxx(
    [(xx, "xx", "xxxx", "xxxxx", xxxx, "x"), (xx, xxxx, "xxxx", "xxxx", xxxx, "x")],
    [(x, "xxxx", x, "x xxxx xx", xxxx, "xxxx", xxxx, "xxxxxx", "xxxxx"),
     (x, "xxxx", x, "x xxxx xx", xxxx, "xxxx", xxxx, "xxxxxx", "xxxxx"),
     (x, "xxxx", x, "x xxxx xx", xxxx, "xxxx", xxxx, "xx", "xxxxx"),
     (x, "xxxx", x, "x xxxx xx", xxxx, "xxxx", xxxx, "xxxxx", "xxxxx")],
    [(x, xx, x), (x, xx, x), (x, xx, x), (x, xx, x)],
    [(xx, xx, "xxxxxx", x, "xx", "xx", "x", "xxxxxxx"),
     (xx, xx, "xxxxxx", x, "xx", "x", "xxx", "xxxxxxx"),
     (xx, xx, "xxxxxx", x, "xx", "xx", "x", "xxxxxxx"),
     (xx, xx, "xxxxxx", x, "xx", "xx", "xx", "xxxxxxxx"),
     (xx, xx, "xxxxxx", x, "xx", "xx", "xxxx", "xxxxxx")],
))
# [('xx xxxx xxxxx', 'xxxxxx', 'x-xxx-xxxxxxx'),
#  ('xxxx xxxx', 'xx', 'xx-xxxx-xxxxxx')]

xxxx xxx xx xxxxxxx xxxxxxx, xx xxx xxxxxxx xx (x, xxxxxx) xxxx, xxx xxx xxxxxxx xxxxx xxxx xxxx xxx xxxxxx. xxxx'x xxxxxxx xxxxxxx xx xx xxx xx; xxx xxx xx xxxxxxx xxxxx, xx xxxxx xx xxxx.

xxxxxxxxxxx

• xx xx xx,xxx xxxxxxxxx, xx,xxx xxxxxxxxx xxx xxxxx, xxx xx,xxx xxxxxx. xxx xxxxx xxxx xxxxxx xx xxxx xxxxxxx.
• xxx xxxxxxxxx xxx xxxxx xx xxxxxxx. xxxxxx xxx xxxxxxxx xxxx xx xxxxxxx xx xxxxxxxx xxxxxx.
• xxx xxxxx xxxxxxx xxx xxxxxx xx xxxxxx xxxx xxx xxx xxxx, xxx xxx xxxxx xx xxx xxxxx: xxx xxxxxxxxx xxxxxxxx xx xxx xxx xxxxxxxxx.