Answer Posted / shrikant tyagi

HOW TO PRINT * ** *** **** ***** BY USING SQL QUERY? (MAY
BE USING SCRIPT)

this is using script;


declare
type a1 is table of varchar2(100);
a a1;
b varchar2(100);
begin
select lpad('*',rownum,'*') bulk collect into a from
lea_agreement_dtl where rownum < 5;
for i in 1..a.count
loop
b:=b||' '||a(i);
end loop;
dbms_output.put_line(b);
end;

What if we write return in procedure?

788

---

What do you understand by exception handling in pl/sql?

577

---

What are the benefits of pl/sql packages?

541

---

How can I delete duplicate rows?

564

---

What is output spooling in sql*plus?

553

---

---

Where can I learn sql for free?

507

---

What is an exception in pl/sql?

544

---

can sql servers linked to other servers like oracle? : Sql dba

552

---

What is minus?

547

---

How sql query is executed?

552

---

What does the base_object_type column shows in the user.triggers data dictionary view?

574

---

What is sql*loader and what is it used for? : aql loader

623

---

What is program debugging?

565

---

What is a column in a table?

554

---

What is varchar sql?

620

---