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 the left table in sql?

521

---

What is sql rowcount?

559

---

What are the properties of a transaction?

573

---

Write a unique difference between a function and a stored procedure.

535

---

Is join an inner join?

540

---

---

What is sql used for?

647

---

How to select random rows from a table?

529

---

Why we use triggers in mysql?

560

---

How do you get column names only for a table (sql server)?

671

---

What are the constraints available in sql?

582

---

what happens if null values are involved in expressions? : Sql dba

571

---

Can a procedure in a package be overloaded?

549

---

How many disk partitions should I have?

557

---

What are the benefits of pl/sql packages?

543

---

What is union and union all keyword in sql?

568

---