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 are different types of indexes?

516

---

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

915

---

How does sql store data?

493

---

how to convert numeric values to character strings? : Sql dba

573

---

what is commit? : Sql dba

623

---

---

What is sql data?

558

---

Is left join faster than join?

554

---

Can we use pl sql in sql server?

545

---

How to pipe multiline string to isql?

585

---

What does sign mean sql?

575

---

What are the types of variable use in pl sql?

569

---

Which are the different case manipulation functions in sql?

539

---

What are variables in pl sql?

577

---

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

782

---

How to create an array in pl/sql?

588

---