Skip to content

Instantly share code, notes, and snippets.

@sujinlee

sujinlee/Variable declaration

Created October 10, 2013 10:46
Show Gist options
  • Save sujinlee/6916494 to your computer and use it in GitHub Desktop.
Save sujinlee/6916494 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Variable declaration
exec :pt_no := '88888888';
select *
from ACPPRICD
where PT_NO = :pt_no ;
define in_pt_no = '88888888'
select *
from ACPPRICD
where PT_NO = &&in_pt_no;
var x refcursor ;
exec PKG_ORDER.SELECTDRUGLIST('', '' ,'811', '1', 'I' ,'Y', '', '', '001000', '1',:x )
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment