Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Draw SQUARE using SQL

blueoraSep 10 2009 — edited Sep 30 2009
How can I write an SQL to generate a square for a specified length?. Using only SQL (no PL SQL).

Assumption - Two characters in the horizontal line is equal to one character in vertical line.

Example

Suppose if length of square is 7 then there will be 14 character in horizontal line and 7 character in vertical line.
**************
*            *
*            *
*            *
*            *
*            *
**************
Please help.

Edited by: user10681556 on Sep 10, 2009 1:26 AM
This post has been answered by Rob van Wijk on Sep 10 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 28 2009
Added on Sep 10 2009
32 comments
6,481 views