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 difference between between and in condition operators?

1063

---

What are the basic techniques of indexing?

1108

---

What does the acronym acid stand for in database management?

1084

---

Can we use two order by clause in query?

1015

---

What is your daily office routine?

2312

---

Differentiate between syntax and runtime errors.

1228

---

What is row_number () in sql?

1021

---

What is secondary key?

982

---

What is the example of procedure?

973

---

What are all the different normalization?

1077

---

Why do we use sql constraints?

1210

---

Could you please provide oca (oracle 10g) dumps for my certification ?

5235

---

Which are the different character-manipulation functions in sql?

1104

---

Does mysql_real_escape_string prevent sql injection?

986

---

What is foreign key in sql with example?

972

---