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

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

980

---

How does one use sql*loader to load images, sound clips and documents? : aql loader

1118

---

Is sql low level language?

961

---

How to run sql*plus commands in sql developer?

1085

---

What is difference between pl and sql?

993

---

What is Materialized View? In What Scenario we Use Materialized View?

9397

---

What is the maximum number of columns in sql table?

1088

---

How do you remove duplicate records from a table?

885

---

Write a sql query to find the names of employees that begin with ‘a’?

951

---

What is form and report?

926

---

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

990

---

Explain polymorphism in pl/sql.

1056

---

Which type of cursor is used to execute the dml statement?

894

---

What is the difference between union and union all command?

1007

---

Why does sql need a server?

988

---