Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

HOW TO PRINT
*
**
***
****
*****
BY USING SQL QUERY? (MAY BE USING SCRIPT)

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of join and explain each?

1048


What is difference between left and right outer join?

988


What is primary key secondary key alternate key candidate key?

1037


Which sql statement is used to return only different values?

1004


how to add a new column to an existing table in mysql? : Sql dba

1073


how do you login to mysql using unix shell? : Sql dba

1081


Why do we use cursors?

990


What is application trigger?

1001


How do I create a sql script?

1103


How would you reference column values before and after you have inserted and deleted triggers?

1065


How can you fetch common records from two tables?

1063


what is commit? : Sql dba

1078


State few characteristics of pl/sql?

971


What is an oracle stored procedure?

1053


Explain correlated query work?

1056