{"id":11,"date":"2012-03-22T18:11:54","date_gmt":"2012-03-22T17:11:54","guid":{"rendered":"http:\/\/clemente.pamplona.name\/dba\/?p=11"},"modified":"2014-02-11T12:36:37","modified_gmt":"2014-02-11T11:36:37","slug":"salida-basica-en-el-sqlplus","status":"publish","type":"post","link":"http:\/\/clemente.pamplona.name\/dba\/salida-basica-en-el-sqlplus\/","title":{"rendered":"Salida b\u00e1sica en el sqlplus"},"content":{"rendered":"<p>A la hora del uso del sqlplus el formateo de\u00a0 la salida es muy importante, tanto en el uso diario como para poder hacer peque\u00f1os scripts.<\/p>\n<p>Algunos comandos b\u00e1sicos son:<\/p>\n<p><strong>Tama\u00f1o de la p\u00e1gina<\/strong><br \/>\nset pagesize 50000<br \/>\n<strong>Tama\u00f1o de la l\u00ednea<\/strong><br \/>\nset linesize 200<br \/>\n<strong>Para ver el comando que ejecutas <\/strong><br \/>\nset echo off<br \/>\n<strong>suppresses the display of output from a command file <\/strong><br \/>\nset termout off<br \/>\n<strong>Quitar las cabeceras <\/strong><br \/>\nset heading off<br \/>\n<strong>Quitar la linea \u00abx rows selected\u00bb <\/strong><br \/>\nset feedback off;<br \/>\n<strong> Formateo de longitud de una columna<\/strong><br \/>\ncolumn XX format a20 (20 catarcetres)<br \/>\ncolumn XX format 999.999 (decimales)<br \/>\ncolumn XX format \u20ac999.999 (ponemos moneda)<br \/>\n<strong>Dejar un log con el nombre del SID siempre y cuando sea una variable global definida<\/strong><br \/>\nspool \/path\/salida_${ORACLE_SID}.log<\/p>\n<p>Algunos enlaces \u00fatiles:<br \/>\n<a title=\"Comandos de sql_plus\" href=\"http:\/\/www.adp-gmbh.ch\/ora\/sqlplus\/\">http:\/\/www.adp-gmbh.ch\/ora\/sqlplus\/<\/a><br \/>\n<a title=\"Sqlplus command line reference\" href=\"http:\/\/docs.oracle.com\/cd\/B19306_01\/server.102\/b14357\/toc.htm\" target=\"_blank\">http:\/\/docs.oracle.com\/cd\/B19306_01\/server.102\/b14357\/toc.htm<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A la hora del uso del sqlplus el formateo de\u00a0 la salida es muy importante, tanto en el uso diario como para poder hacer peque\u00f1os scripts. Algunos comandos b\u00e1sicos son: Tama\u00f1o de la p\u00e1gina set pagesize 50000 Tama\u00f1o de la &hellip; <a href=\"http:\/\/clemente.pamplona.name\/dba\/salida-basica-en-el-sqlplus\/\">Sigue leyendo <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,7],"tags":[248,247],"class_list":["post-11","post","type-post","status-publish","format-standard","hentry","category-dummie","category-sqlplus","tag-dummie","tag-sqlplus"],"_links":{"self":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/11","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/comments?post=11"}],"version-history":[{"count":10,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/11\/revisions"}],"predecessor-version":[{"id":871,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/11\/revisions\/871"}],"wp:attachment":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/media?parent=11"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/categories?post=11"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/tags?post=11"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}