Answer Posted / sumit

declare
abc varchar2(500) ;
begin
select 1||chr(0)||2||chr(0)||3 ..... into
abc from dual;
dbms_output.put_line(abc);
end;

cannot use chr(10) to take columns in sql.

way is to use rownum,row_number or any psuedo column like
sequence

Do prepared statements prevent sql injection?

536

---

How is use pl and sql?

560

---

how to install mysql? : Sql dba

590

---

What is the use of count (*) in sql?

554

---

What is primary key and foreign key?

543

---

---

Are stored procedures compiled?

531

---

What is raid? How does it help storage of databases?

612

---

What is rtm stands for?

588

---

What is the syntax to add a record to a table?

583

---

Does asenumerable execute the query?

609

---

what is msql? : Sql dba

572

---

What is nvl?

617

---

What is mutating error?

514

---

How to Declare Fixed Length String Value In PL SQL

675

---

what are different types of collation sensitivity? : Sql dba

566

---