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;

How to look at the current sql*plus system settings?

1211

---

What is a nested table in word?

1007

---

What is difference between nchar and nvarchar?

1098

---

What is sql data?

1032

---

What is sql injection vulnerability?

1005

---

Can you selectively load only those records that you need? : aql loader

1092

---

What is the use of nvl function?

1239

---

what is query cache in mysql? : Sql dba

1078

---

What is asqueryable?

1035

---

Does pl sql work in mysql?

1033

---

When sql appeared?

1146

---

What types of commands can be executed in sql*plus?

1151

---

How is data stored in sql?

1101

---

What are all the different normalizations?

1076

---

What is view explain with example?

994

---