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 is cartesian join in sql?

1185

---

What are the subsets of sql?

1190

---

What are aggregate functions in sql?

1218

---

How do I get sql certification?

1011

---

What jobs use sql?

1029

---

Is sqlite good enough for production?

1036

---

What is the use of function "module procedure" in pl/sql?

1233

---

Can we rollback delete command?

1032

---

When to use inner join and left join?

1004

---

What is constant in pl sql?

1059

---

What is the max nvarchar size?

1024

---

What is a delimiter in sas?

1121

---

How to get list of all tables from a database?

1202

---

What is the command used to fetch first 5 characters of the string?

1459

---

What is the difference between partition and index?

1041

---