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;

What does stand for in sql?

966

---

What are sql indexes?

999

---

What is a record in a database?

1062

---

What are the parts of a basic sql query?

967

---

What is the difference between cross join and natural join?

1020

---

What is trigger in pl sql?

994

---

Does sql require a server?

1011

---

Define commit?

998

---

how do you tune the slow running queries in oracle db , explain the methodology

2775

---

What is procedure and function in sql?

997

---

how would you get the current date in mysql? : Sql dba

967

---

How to display Row Number with Records in Oracle SQL Plus?

1047

---

What is nested table in pl sql?

1070

---

Can a trigger call a stored procedure?

1070

---

What is string join?

974

---