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 are the different ways to optimize a sql query?

950

---

How do you create a db file?

1020

---

What is difference between inner join and self join?

1090

---

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

1006

---

Which data type is a composite type?

993

---

what is a materialized view? : Sql dba

1068

---

What is embedded sql what are its advantages?

1045

---

What is difference between pl and sql?

1068

---

What is an inner join sql?

1037

---

Show how functions and procedures are called in a pl/sql block.

1133

---

Can a table contain multiple primary key’s?

1104

---

what is schema? : Sql dba

1052

---

Is sql low level language?

1024

---

What is rank function in sql?

1033

---

what is rdbms? : Sql dba

1018

---