Overview | Syntax | Customization | Examples

> select name, character_length(name) len from individuals;

NAME                                                LEN
--------------------------------------------------  -----------
MS. MARY LEWIS                                               14
MRS. ALICE R TOLLIVER                                        21
MR. SIDNEY K TOLLIVER                                        21
MRS. JENNIFER J HOPKINS                                      23
MR. CHARLIE HOPKINS                                          19
MS. KIMBERLY BLUE                                            17
KATHLEEN TUCKER                                              15

> select gender, name, char_length(gender || name) len from individuals;

G  NAME                                                LEN
-  --------------------------------------------------  -----------
F  MS. MARY LEWIS                                               15
F  MRS. ALICE R TOLLIVER                                        22
M  MR. SIDNEY K TOLLIVER                                        22
F  MRS. JENNIFER J HOPKINS                                      24
M  MR. CHARLIE HOPKINS                                          20
F  MS. KIMBERLY BLUE                                            18
F  KATHLEEN TUCKER                                              16

Next

See also: