snipt

Ctrl+h for KB shortcuts

PL/pgSQL

DEFINIR NOMBRE DE PROGRAMAS EN ORACLE

DBMS_APPLICATION_INFO.SET_MODULE('Discoverer902', '');
https://snipt.net/embed/6e448216f44d83ff635364d6374cfebd/
https://snipt.net/raw/6e448216f44d83ff635364d6374cfebd/
6e448216f44d83ff635364d6374cfebd
plpgsql
PL/pgSQL
1
2016-09-23T06:49:51
True
False
True
Jan 21, 2013 at 10:09 AM
/api/public/snipt/54145/
definir-nombre-de-programas-en-oracle
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a></pre></div></td><td class="code"><div class="highlight"><pre><span id="L-1"><a name="L-1"></a><span class="n">DBMS_APPLICATION_INFO</span><span class="mf">.</span><span class="n">SET_MODULE</span><span class="p">(</span><span class="s1">&#39;Discoverer902&#39;</span><span class="p">,</span> <span class="s1">&#39;&#39;</span><span class="p">);</span> </span></pre></div> </td></tr></table>
DBA, ORACLE, PLSQL, SQL

SQL

Coneccion DBA oracle

1
2
3
4
5
6
7
8
---MODO DE 1
   sqlplus / as sysdba

--modo 2

  sqlplus /nolog

  conn / as sysdba
https://snipt.net/embed/232ad7a838e062adcf03d1fa1a2515e9/
https://snipt.net/raw/232ad7a838e062adcf03d1fa1a2515e9/
232ad7a838e062adcf03d1fa1a2515e9
sql
SQL
8
2016-09-23T06:49:54
True
False
True
Jan 21, 2013 at 10:07 AM
/api/public/snipt/54144/
coneccion-dba-oracle
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a> <a href="#L-2">2</a> <a href="#L-3">3</a> <a href="#L-4">4</a> <a href="#L-5">5</a> <a href="#L-6">6</a> <a href="#L-7">7</a> <a href="#L-8">8</a></pre></div></td><td class="code"><div class="highlight"><pre><span id="L-1"><a name="L-1"></a><span class="c1">---MODO DE 1</span> </span><span id="L-2"><a name="L-2"></a> <span class="n">sqlplus</span> <span class="o">/</span> <span class="k">as</span> <span class="n">sysdba</span> </span><span id="L-3"><a name="L-3"></a> </span><span id="L-4"><a name="L-4"></a><span class="c1">--modo 2</span> </span><span id="L-5"><a name="L-5"></a> </span><span id="L-6"><a name="L-6"></a> <span class="n">sqlplus</span> <span class="o">/</span><span class="n">nolog</span> </span><span id="L-7"><a name="L-7"></a> </span><span id="L-8"><a name="L-8"></a> <span class="n">conn</span> <span class="o">/</span> <span class="k">as</span> <span class="n">sysdba</span> </span></pre></div> </td></tr></table>
DBA, ORACLE, SQL

SQL

Ver/Compliar OBjetos de BD

1
2
3
4
5
6
Select 'ALTER ' ||
       Decode(Object_Type, 'PACKAGE BODY', 'PACKAGE', Object_Type) || ' ' ||
       Object_Name || ' COMPILE' ||
       Decode(Object_Type, 'PACKAGE BODY', ' body;', ';')
  From User_Objects 
 Where Status = 'INVALID' And OBJECT_TYPE In ('PACKAGE BODY','PACKAGE')--quit all object or filter;
https://snipt.net/embed/cac2501bc5b378250bd1be5b6ac4b5c7/
https://snipt.net/raw/cac2501bc5b378250bd1be5b6ac4b5c7/
cac2501bc5b378250bd1be5b6ac4b5c7
sql
SQL
7
2016-09-24T03:00:38
True
False
True
Jan 21, 2013 at 09:32 AM
/api/public/snipt/54141/
vercompliar-objetos-de-bd
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a> <a href="#L-2">2</a> <a href="#L-3">3</a> <a href="#L-4">4</a> <a href="#L-5">5</a> <a href="#L-6">6</a></pre></div></td><td class="code"><div class="highlight"><pre><span id="L-1"><a name="L-1"></a><span class="k">Select</span> <span class="s1">&#39;ALTER &#39;</span> <span class="o">||</span> </span><span id="L-2"><a name="L-2"></a> <span class="n">Decode</span><span class="p">(</span><span class="n">Object_Type</span><span class="p">,</span> <span class="s1">&#39;PACKAGE BODY&#39;</span><span class="p">,</span> <span class="s1">&#39;PACKAGE&#39;</span><span class="p">,</span> <span class="n">Object_Type</span><span class="p">)</span> <span class="o">||</span> <span class="s1">&#39; &#39;</span> <span class="o">||</span> </span><span id="L-3"><a name="L-3"></a> <span class="n">Object_Name</span> <span class="o">||</span> <span class="s1">&#39; COMPILE&#39;</span> <span class="o">||</span> </span><span id="L-4"><a name="L-4"></a> <span class="n">Decode</span><span class="p">(</span><span class="n">Object_Type</span><span class="p">,</span> <span class="s1">&#39;PACKAGE BODY&#39;</span><span class="p">,</span> <span class="s1">&#39; body;&#39;</span><span class="p">,</span> <span class="s1">&#39;;&#39;</span><span class="p">)</span> </span><span id="L-5"><a name="L-5"></a> <span class="k">From</span> <span class="n">User_Objects</span> </span><span id="L-6"><a name="L-6"></a> <span class="k">Where</span> <span class="n">Status</span> <span class="o">=</span> <span class="s1">&#39;INVALID&#39;</span> <span class="k">And</span> <span class="n">OBJECT_TYPE</span> <span class="k">In</span> <span class="p">(</span><span class="s1">&#39;PACKAGE BODY&#39;</span><span class="p">,</span><span class="s1">&#39;PACKAGE&#39;</span><span class="p">)</span><span class="c1">--quit all object or filter;</span> </span></pre></div> </td></tr></table>
DBA, ORACLE, SQL, compliler
Copyrighted, illegal, or inappropriate content? Email support@snipt.net.