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

Which query operators in sql is used for pattern matching?

1011

---

Define tables and fields in a database

1178

---

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1056

---

What are the advantages of pl sql over sql?

1074

---

What is dml and ddl?

1010

---

What is range partitioning?

1014

---

what is table? : Sql dba

1109

---

What does count (*) do in sql?

1050

---

What is the difference between microsoft access and sql server?

1107

---

what is isam? : Sql dba

1066

---

What is the difference between functions, procedures, and packages in pl/sql?

1095

---

What is bind variable in pl sql?

1105

---

how can we submit a form without a submit button? : Sql dba

1036

---

What is sqlservr exe?

1028

---

What are the ddl commands?

1055

---