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 is sql stand for?

947

---

What is rownum and rowid?

985

---

what are string data types? : Sql dba

975

---

What is microsoft t sql?

882

---

What are all the different normalizations?

972

---

Mention what are different methods to trace the pl/sql code?

1108

---

Which are the different case manipulation functions in sql?

955

---

What are predefined functions in sql?

980

---

how to calculate expressions with sql statements? : Sql dba

985

---

Explain what is sql*plus?

1087

---

What are sql commands?

938

---

how to use regular expression in pattern match conditions? : Sql dba

966

---

Can we use ddl commands in pl sql?

1075

---

what are the drivers in mysql? : Sql dba

985

---

how to decrement dates by 1 in mysql? : Sql dba

970

---