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: 
ifelse works like this: `ifelse(condition, yes, no)`. In this case you can write `ifelse(condition = Style == "Hallo", yes = "1", no = NA)`. In your case your `no` statement would be another `ifelse`.

Using case\_when might be better in this case:

```
Data %>%
  mutate(Style_Numeric = case_when(Style == "Hallo" ~  1, 
                                   Style == "Hello" ~ 2,
                                   Style == "Bonjour" ~ 3, 
                                   Style == "Bye" ~ 4, 
                                   Style == "Au Revoir" ~ 5))

```
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))

```