{"id":2363,"date":"2022-11-03T08:58:45","date_gmt":"2022-11-03T07:58:45","guid":{"rendered":"http:\/\/clemente.pamplona.name\/dba\/?p=2363"},"modified":"2023-11-03T09:03:46","modified_gmt":"2023-11-03T08:03:46","slug":"formatear-el-prompt-del-sqlplus","status":"publish","type":"post","link":"http:\/\/clemente.pamplona.name\/dba\/formatear-el-prompt-del-sqlplus\/","title":{"rendered":"Formatear el prompt del SQLplus"},"content":{"rendered":"<p>Hoy vamos a ver una entrada muuy sencilla de como formatear el prompt de SQLPLUS<br \/>\nBajo nuestro oracle home tenemos un fichero llamado <b>glogin.sql<\/b> donde podemos definir las variables del sqlplus, entre ellas el prompt.<br \/>\nSupongaamos que queremos saber cual es el usuario con el que nos conectamos, seria tan sencillo como aniadir la linea <\/p>\n<pre>\r\ndbserver01:vi \/u01\/app\/oracle\/product\/19c\/dbhome_1\/sqlplus\/admin\/glogin.sql\r\n--\r\n-- Copyright (c) 1988, 2005, Oracle.  All Rights Reserved.\r\n--\r\n-- NAME\r\n--   glogin.sql\r\n--\r\n-- DESCRIPTION\r\n--   SQL*Plus global login \"site profile\" file\r\n--\r\n--   Add any SQL*Plus commands here that are to be executed when a\r\n--   user starts SQL*Plus, or uses the SQL*Plus CONNECT command.\r\n--\r\n-- USAGE\r\n--   This script is automatically run\r\n--\r\ndef _editor=vi\r\nset timing on\r\nset feedback on\r\nset sqlprompt \"_user  _connect_identifier > \"\r\n<\/pre>\n<p>Ms informacion, en:<\/p>\n<ul>\n<li>https:\/\/www.youtube.com\/watch?v=Ax4s39KfcZ8\n<li>https:\/\/www.oreilly.com\/library\/view\/oracle-sqlplus-the\/0596007469\/re95.html\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Hoy vamos a ver una entrada muuy sencilla de como formatear el prompt de SQLPLUS Bajo nuestro oracle home tenemos un fichero llamado glogin.sql donde podemos definir las variables del sqlplus, entre ellas el prompt. Supongaamos que queremos saber cual &hellip; <a href=\"http:\/\/clemente.pamplona.name\/dba\/formatear-el-prompt-del-sqlplus\/\">Sigue leyendo <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[565,567,921,975,51,9,7],"tags":[247,1036],"class_list":["post-2363","post","type-post","status-publish","format-standard","hentry","category-11g-en","category-12c-en","category-18c","category-19c","category-cliente","category-dummie","category-sqlplus","tag-sqlplus","tag-sqlprompt"],"_links":{"self":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2363","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=2363"}],"version-history":[{"count":2,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2363\/revisions"}],"predecessor-version":[{"id":2365,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2363\/revisions\/2365"}],"wp:attachment":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/media?parent=2363"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/categories?post=2363"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/tags?post=2363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}