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;

What is the difference between union and union all command?

1076

---

What is delete command in sql?

1101

---

how do you know if your mysql server is alive? : Sql dba

1070

---

What is #table in sql?

1077

---

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

1035

---

What is the maximum rows in csv?

916

---

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1046

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

944

---

How will you distinguish a global variable with a local variable in pl/sql?

1143

---

Can you do multiple joins in sql?

1034

---

How to place comments in pl/sql?

1145

---

What is loop in pl sql?

1031

---

How much does sql certification cost?

1074

---

What is mutating table error?

1169

---

How do I create a sql script?

1093

---