Answer / 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;
```

What are the different datatypes available in PL/SQL?

1 Answers  

---

Can we perform dml on view?

1 Answers  

---

What are the sql aggregate functions?

1 Answers  

---

Explain table and field in sql?

1 Answers  

---

what is acid property in database? : Sql dba

1 Answers  

---

What is pl sql code?

1 Answers  

---

How do you update a table in sql?

1 Answers  

---

Show the cursor attributes of pl/sql.

1 Answers  

---

How do I remove sql plus from windows 10?

1 Answers  

---

What is your daily office routine?

0 Answers   Data Vision,

---

What are the types of subqueries?

1 Answers  

---

mail-id table contains two columns(email_id,userid) it contains different types of mail-ids,and no of users. here username length is differ na,(ex- tamil@yahoo.com,joshua@hotmail.com like) now i want to fetch the email-ids only starting from '@' (ex-@gmail.com,@yahoo.com,@hotmail.com

5 Answers  

---