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;

How to return an array from java to pl/sql?

1114

---

How to create a menu in sqlplus or pl/sql?

1101

---

What is pl sql block in dbms?

991

---

how to create a new view in mysql? : Sql dba

924

---

What is a memo field?

946

---

what is a tablespace? : Sql dba

1038

---

Why do we use sql constraints?

1154

---

What is the left table in sql?

952

---

How do you update a sql procedure?

1012

---

how many triggers are allowed in mysql table? : Sql dba

1041

---

What is a unique constraint?

1060

---

How do I run a sql script?

1121

---

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1131

---

Why is there a need for sqlcode and sqlerrm variables?

1030

---

Does inner join return duplicate rows?

962

---