Answer Posted / shrikant tyagi in nucleus soft

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;

How many commands are there in sql?

549

---

What is pl sql package?

593

---

what is collation? : Sql dba

616

---

What is an exception in pl/sql?

544

---

Should I use mbr or gpt?

546

---

---

Is left join faster than inner join?

617

---

How do I trace sql profiler?

491

---

What is data type in database?

546

---

How many types of normalization are there?

491

---

What is bind variable in pl sql?

530

---

How can get second highest salary in sql?

509

---

Explain what is a view?

600

---

What are the different types of dbms?

554

---

How many types of triggers exist in pl/sql?

567

---

Explain the update statement in sql

562

---