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

Why is pl sql used?

541

---

Can we use two order by clause in query?

559

---

What is %type in sql?

531

---

How to call a javascript function from pl sql?

581

---

How many disk partitions should I have?

565

---

---

how is exception handling handled in mysql? : Sql dba

563

---

how to install mysql? : Sql dba

598

---

What is gpt format?

517

---

What is cursor and its types?

572

---

What is the use of sql trace?

489

---

Why do we use cursors?

526

---

What is percent sign in sql?

738

---

Which table is left in left join?

554

---

How does a trigger work?

551

---

which types of join is used in sql widely? : Sql dba

548

---