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

Can you upgrade sql express to full sql?

506

---

what is self join and what is the requirement of self join? : Sql dba

673

---

What is the difference between database trigger and stored procedure?

546

---

List out the acid properties and explain?

555

---

Explain unique key in sql.

552

---

---

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

527

---

Can we call procedure in select statement?

512

---

Determine if oracle date is on a weekend?

548

---

What are stored procedures used for?

528

---

What are triggers in sql?

574

---

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

568

---

What is sql partition function?

608

---

what is a database? : Sql dba

599

---

What is the starting oracle error number?

558

---

Does oracle roll back the transaction on an error?

525

---