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!

How to apply the following prompt in SQL

user10566312Dec 3 2012 — edited Dec 3 2012
Hi I want to apply a prompt condition which would ask user to enter the a date in a given format. I want to display the following message Enter created date (DD-MON-YYYY HH24:MI:SS).

Select *
From tb1
Where created_dt > to_date('&Enter created date (DD-MON-YYYY HH24:MI:SS)', 'DD-MON-YYYY HH24:MI:SS')
This post has been answered by BluShadow on Dec 3 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 31 2012
Added on Dec 3 2012
12 comments
460 views