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;

What are commit, rollback, and savepoint?

967

---

What are inner outer left and right joins in sql?

998

---

what is the difference between blob and text? : Sql dba

1003

---

How many scalar data types are supported in pl/sql?

1028

---

What is the advantage of nosql?

1043

---

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1046

---

List the various privileges that a user can grant to another user?

1033

---

What is triggering circuit?

1050

---

what are all the different normalizations? : Sql dba

1016

---

What are the different dcl commands in sql?

1120

---

What is the difference between python and sql?

973

---

What are all different types of collation sensitivity?

1015

---

Are there any features that are decommissioned in 11g that are not present in 11g?

2125

---

what are all different types of collation sensitivity? : Sql dba

969

---

what is innodb? : Sql dba

1085

---