Answer Posted / Satish Rai

To convert a comma-separated string into an array (PL/SQL table) in PL/SQL, you can use the DBMS_UTILITY.COMMA_TO_TABLE function. Here's an example:
```
DECLARE
my_string VARCHAR2(4000) := 'value1, value2, value3';
my_table MY_TABLE%TYPE;
BEGIN
DBMS_UTILITY.COMMA_TO_TABLE(my_string, my_table);
END;
```

how to escape special characters in sql statements? : Sql dba

1124

---

Can delete statement be rollbacked?

1065

---

what are the advantages of sql ? : Sql dba

1154

---

What is the current version of postgresql?

1189

---

What is your daily office routine?

2353

---

Can we rollback truncate?

1086

---

how to use regular expression in pattern match conditions? : Sql dba

1125

---

what is sql server agent? : Sql dba

1190

---

If a cursor is open, how can we find in a pl/sql block?

1252

---

what is dbms? : Sql dba

1072

---

how many tables will create when we create table, what are they? : Sql dba

1157

---

what is schema? : Sql dba

1165

---

define sql insert statement ? : Sql dba

1110

---

what is bcp? When does it used? : Sql dba

1065

---

Is primary key always clustered index?

1101

---