Data obtained from a SQL derived table can then be inserted into a new table, as in the following example.
select pubdate into pub_dates from (select pubdate from titles) dt_e where pubdate = "450128 12:30:1PM"
Here, data from the SQL derived table dt_e is inserted into the new table pub_dates.
Copyright © 2005. Sybase Inc. All rights reserved. |