5 Replies Latest reply on May 26, 2008 11:46 AM by Laurent Schneider

    Substitution variables in Sql*Plus

      Hi all,

      How to make Sql*Plus ask for the substitution variable value one time only for a substitution variable even if it appears multiple times inside a query ? Because so far each time I launched the query below then I have been asked two times by Sql*Plus for the variable value. For example : select ref_site from t_comsis where longitude_lamb + latitude_lamb < &distance + power(&distance,2).