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

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 28 2009

Added on Sep 10 2009

32 comments

6,480 views