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;

Is it mandatory for the primary key to be given a value when a new record is inserted?

1139

---

What is sql and explain its components?

1006

---

How do you identify a primary key?

1010

---

What is clause?

1062

---

How can you save or place your msg in a table?

952

---

How do I count duplicates in sql?

1024

---

What are the different sql commands?

1000

---

How to write pl sql program in mysql command prompt?

1006

---

Can we have two clustered index on a table?

963

---

What is cursor and why it is required?

1105

---

what is commit? : Sql dba

1025

---

How to run pl sql program in mysql?

938

---

What is dml with example?

1011

---

what are different types of keys in sql?

1063

---

what is a constraint? Tell me about its various levels. : Sql dba

924

---