Skip to Main Content
Forums

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!

To display 01 to 10 using select query

Hariharan STApr 10 2008 — edited Apr 10 2008
Hi all,

using select query...

In where clause...,
If u give 1 to 9 it should display 01 to 09 and
If u give 10 it should display as 10.

I want it in a single query .

Thanks & Regards,
Hariharan ST.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 8 2008
Added on Apr 10 2008
15 comments
1,161 views