HOW TO PRINT
*
**
***
****
*****
BY USING SQL QUERY? (MAY BE USING SCRIPT)
Answers were Sorted based on User's Feedback
Answer / kart
select lpad('*',rownum,'*') Star from person where rownum<6
*
**
***
****
*****
Is This Answer Correct ? | 20 Yes | 4 No |
Answer / shivaindu
select lpad('*',rownum,'*') Star from dual connect by level < 6;
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / swastik
SELECT
LPAD('*',ROWNUM,'*') Stars
FROM ALL_OBJECTS
WHERE ROWNUM <= 5
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / bijaylaxmi
declare
m number:=5;
n varchar2(30);
begin
for i in 1..m
loop
for j in 1..i
loop
n:=n||'*';
end loop;
dbms_output.put_line(n);
n:=null;
end loop;
end;
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 This Answer Correct ? | 0 Yes | 0 No |
Answer / s m nadeem
Declare
type stars is table of varchar2(10);
v_star stars;
v_str varchar2(10);
Begin
select lpad('*', rownum, '*')
bulk collect
into v_star
from tab_star
where rownum < 6;
for i in 1 .. v_star.count loop
v_str := v_star(i);
dbms_output.put_line(v_str);
End loop;
End;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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;
Is This Answer Correct ? | 0 Yes | 2 No |
how view used for security purposes?
i have some prob lem to tell me about my self in interview first round ...
how can we submit a form without a submit button? : Sql dba
Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F
Is sql pronounced sequel or sql?
how can i create a user defined datatype
What do you mean by field in sql?
what are the different functions in sorting an array? : Sql dba
describe mysql connection using mysql binary. : Sql dba
What are sql functions? Describe in brief different types of sql functions?
From an Employee table, how will you display the record which has a maximum salary?
29 Answers Cap Gemini, Exilant, Synechron,
What is meant by Materialized view?
2 Answers iGate, Marlabs, Polaris,