hackvan

Declare
  pevc_codlibori sfci001t.codlibro%Type := 'PUC001';
  pevc_codctaori sfci001t.codctaco%Type := '244001';
  pevc_nivan1ori sfci019t.nivanal1%Type := 'TNEG';
  pevc_codan1ori sfci019t.codniva1%Type := '1234';
  pevc_nivan2ori sfci019t.nivanal2%Type := 'NIT';
  pevc_codan2ori sfci019t.codniva2%Type := '5678';
  pevc_nivan3ori sfci019t.nivanal3%Type := 'VIGE';
  pevc_codan3ori sfci019t.codniva3%Type := '2016'; 
  pevc_nivan4ori sfci019t.nivanal4%Type;

hackvan

Declare
  Cursor cuprincipal Is
    Select '1' as Data From dual 
    Union 
    Select '2' as Data From dual 
    Union 
    Select '3' as Data From dual 
    Union 
    Select '4' as Data From dual 
    Union 

hackvan

Create Or Replace Function getCodSeq(xcodseque In Varchar2,xtam In Number Default Null) Return Varchar2 Is
  xvalseque sfad012t.valseque%Type;
  xcodprefi sfad012t.codprefi%Type;
  xseque    Varchar2(50);
  Cursor c1 Is
    Select nvl(valseque, 0) + nvl(incseque, 1), codprefi 
    Into   xvalseque, xcodprefi 
    From   sfad012t 
    Where  codseque = xcodseque
    For Update Of valseque;

hackvan

Create Or Replace Procedure do_something(pevc_codbanco In Varchar2) Is
  row_locked Exception;
  Pragma Exception_Init(row_locked, -54); -- ORA-00054: recurso ocupado y obtenido con NOWAIT especificado o timeout vencido
Begin
  For cc In (Select codbanco From sfcp005t Where codbanco = pevc_codbanco For Update Nowait) Loop
    Exit;
  End Loop;
Exception
  When row_locked Then
    raise_application_error(-20001, 'this row is locked...', False);

hackvan

CREATE TABLE test (
testcol VARCHAR2(15));
INSERT INTO test VALUES ('dummy');
COMMIT;

hackvan

Prereq:

apt-get install zsh
apt-get install git-core

Getting zsh to work in ubuntu is weird, since sh does not understand the source command. So, you do this to install zsh

wget https://github.com/robbyrussell/oh-my-zsh/raw/master/tools/install.sh -O - | zsh

hackvan

Declare
  nextvalnotfound Exception;
  Pragma Exception_Init(nextvalnotfound, -08002);
  lc_secuencia Number;
Begin
  SELECT sfps010s.currval INTO lc_secuencia FROM dual;
Exception
  When nextvalnotfound Then
    dbms_output.put_line('NextVal is not found it!');
  When Others Then

hackvan

PSQL

To have launchd start postgresql now and restart at login:

brew services start postgresql

Or, if you don't want/need a background service you can just run:

pg_ctl -D /usr/local/var/postgres start

hackvan

export PATH="/usr/local/bin:$PATH"

hackvan

<?php 
  $x = 0; 
  $x = $x + 1; 
  $x = $x + 2; 
  $x = $x + 3; 
  print($x); 
?>