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 to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?
What is an exception in pl/sql?
How to Execute a Package in PL/SQL.?
What is the difference between between and in condition operators?
What is lexical units in pl sql?
How many sql are there?
what are the advantages of mysql in comparison to oracle? : Sql dba
how can i create a user defined datatype
What are some predefined exceptions in pl/sql?
How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?