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!

SQL & operator to read user input

451025Jun 1 2011 — edited Jun 1 2011

Select employee_id, employee_name from employee where start_date between '&Enter employee start date(format DD-MON-YY HH24:MI:SS)' and '&Enter employee end date(format DD-MON-YY HH24:MI:SS)'

above query is not able to display full text for reading the format

only Enter is displayed and the rest is getting truncated. Can you please help me in using escape characters for spaces and -

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 29 2011

Added on Jun 1 2011

#sql

4 comments

4,760 views