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 the join types in tsql? : Transact sql

1064

---

Enlist the data types that can be used in pl/sql?

1073

---

Can we create table inside stored procedure?

955

---

Are subqueries faster than joins?

1021

---

What is a sql statement?

963

---

How to run sql functions in pl/sql?

1054

---

Write a query to display the current date in sql?

1020

---

How does cross join work?

957

---

what is the functionality of the function htmlentities? : Sql dba

962

---

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

990

---

What are the different types of functions in sql?

1055

---

What is the usage of distinct keyword?

1067

---

What does pl sql developer do?

926

---

What is the difference between null value, zero, and blank space?

1205

---

What is the difference between in and between in sql?

1061

---