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 sqlerrd 3?

936

---

how can you create an empty table from an existing table? : Sql dba

1146

---

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

975

---

Write a sql query to get the third highest salary of an employee from employee_table?

1064

---

What are the steps for performance tuning.

1324

---

What is trigger types in sql?

981

---

What is spool?

1045

---

what is the difference between group by and order by in sql? : Sql dba

1113

---

What is a scalar value in sql?

1065

---

What is a call statement? Explain with an example.

996

---

How do you identify a primary key?

1057

---

What are the basic techniques of indexing?

1056

---

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2564

---

In pl/sql, what is bulk binding, and when/how would it help performance?

985

---

What is pl sql quora?

1132

---