Question: In my Oracle table, I have a column with Number of Seconds since midnight (like 75135) and I want to identify its human readable time format. Do we have any command in Oracle ? please help me on this

Regards,
Manohar

Answer: 
You could also use `dplyr::recode` and do it in one go:

```r
Data <- Data %>%
  mutate(Style_Numeric = dplyr::recode(Style, 
                                Hallo = 1,
                                Bonjour = 3,
                                Bye = 4,
                                `Au Revoir` = 5,
                                Hello = 2))

```
`data.table` option using `fifelse`:

```
library(data.table)
setDT(Data)
Data[, Style_Numeric := fifelse(Style == "Hallo", "1", 
                        fifelse(Style == "Hello", "2",
                        fifelse(Style == "Bonjour", "3",
                        fifelse(Style == "Bye", "4",
                        fifelse(Style == "Au Revoir", "5", Style)))))]
Data

```

Output:

```
   Name     Style Style_Numeric
1:    A     Hello             2
2:    B   Bonjour             3
3:    C     Hallo             1
4:    D       Bye             4
5:    E Au Revoir             5

```