I have a *clob* column in my table, in which I store **JSON** string. the data in the column is something like below:

```json
{
  "date": "2021/11/11",
  "name": "test",
  "errorCode": "00000",
  "type": "test"
}

```

I want to write a select query to get the name.
Any suggestions?