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;

Explain what is sql?

1119

---

how to shutdown mysql server? : Sql dba

1107

---

How do I save a stored procedure?

1011

---

What are the different types of tables in sql?

1009

---

Is sql harder than python?

1110

---

What is the process of debugging?

1074

---

What is trigger price?

996

---

What is clause in sql?

1114

---

What kind of join is join?

975

---

Why procedure is used in sql?

1041

---

Is primary key clustered or nonclustered?

1021

---

What are inner outer left and right joins in sql?

1016

---

What is thread join () in threading?

1018

---

how do you control the max size of a heap table? : Sql dba

983

---

Why we use sql profiler?

963

---