How to list posts within a page

You need to PHP Exec plugin (here), to execute php within a post or page area. Then, in the post (or page) you want the listing, use the php you want to call on the database – probably something like this
<p><?php wp_get_archives('type=postbypost&limit=20&format=custom'); ?></p>
See http://codex.wordpress.org/Template_Tags/wp_get_archives to tweak the results of what shows up….