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

How do I add a database to sql?

1121

---

What are analytic functions in sql?

1021

---

Why we use joins in sql?

975

---

Is it possible to include an insert statement on the same table to which the trigger is assigned?

1010

---

How run sql*plus commands that are stored in a local file?

1054

---

What is scope of pl sql developer in future?

1013

---

Does access use sql?

1031

---

Differentiate between syntax and runtime errors.

1178

---

what is union, minus and interact commands? : Sql dba

1180

---

What is a ddl command?

1080

---

What does count (*) mean in sql?

1576

---

Can we perform dml on view?

1040

---

What is the difference between inner join and left join?

982

---

What is an oracle stored procedure?

1043

---

How do you write a complex sql query?

1056

---