sentencia1.log<\/em><\/p>\n <\/p>\n
Ahora podemos lanzar nuestro fichero .sql que incluye m\u00faltiples sentencias SQL:<\/p>\n
\r\n22:10:04 host:SYS.instanciaBBDD>@\/var\/tmp\/sentencia1.sql\r\n<\/pre>\n <\/p>\n
O ejecutar otras sentencias o consultas.<\/p>\n
<\/p>\n
Tras ejecutarse el fichero .sql, el fichero de log habr\u00e1 recibido la salida de la ejecuci\u00f3n, y podremos desactivar de nuevo SPOOL.<\/p>\n
\r\nspool off\r\n<\/pre>\n <\/p>\n
Ahora ya podemos revisar el fichero de log en el que se habr\u00e1 registrado todo lo que hayamos ejecutado en la sesi\u00f3n de SQL Plus en Oracle.<\/p>\n
<\/p>\n\n
<\/div>","protected":false},"excerpt":{"rendered":"
Vamos a ver c\u00f3mo exportar datos de una consulta de una base de datos Oracle a un fichero.<\/p>\n","protected":false},"author":1,"featured_media":30269,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false},"categories":[85],"tags":[1288],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/eltallerdelbit.com\/wp-json\/wp\/v2\/posts\/30260"}],"collection":[{"href":"https:\/\/eltallerdelbit.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eltallerdelbit.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eltallerdelbit.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eltallerdelbit.com\/wp-json\/wp\/v2\/comments?post=30260"}],"version-history":[{"count":2,"href":"https:\/\/eltallerdelbit.com\/wp-json\/wp\/v2\/posts\/30260\/revisions"}],"predecessor-version":[{"id":30629,"href":"https:\/\/eltallerdelbit.com\/wp-json\/wp\/v2\/posts\/30260\/revisions\/30629"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/eltallerdelbit.com\/wp-json\/wp\/v2\/media\/30269"}],"wp:attachment":[{"href":"https:\/\/eltallerdelbit.com\/wp-json\/wp\/v2\/media?parent=30260"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eltallerdelbit.com\/wp-json\/wp\/v2\/categories?post=30260"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eltallerdelbit.com\/wp-json\/wp\/v2\/tags?post=30260"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}