On Thu, Aug 7, 2014 at 11:50 PM, vpmm2007 wrote:
> create or replace package CUM_A_TYPES
> as
> type LT_PAYMENT is record
> (BASICnumber,
> DPnumber,
> GRADE_PAYnumber
> );
> TYPE TYPE_CALC_TAX is record
> (
> FIN_ROLE_ID number(8),
> CALC_FOR_ROLE_CODE number(
On 08/10/2014 09:50 PM, Vaishali Maheshkar wrote:
SIR,
THANKS FOR YOUR REPLY ,
CCing list.
actually i m trying to create record type data in postgres , but i cant
declare it directly as in oracle my purpose is to create types of record
type in oracle it was done by creating a package and d
type function is record (f1 NUMERIC,f2 NUMERIC..); this is in oracle
kindly tell me what is the substitute to use "is record " in postgres.
its urgent .
thanks and rgds
vpmm
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/postgresql-referencing-and-creating-type
On 08/07/2014 09:50 PM, vpmm2007 wrote:
create or replace package CUM_A_TYPES
as
type LT_PAYMENT is record
(BASICnumber,
DPnumber,
GRADE_PAYnumber
);
TYPE TYPE_CALC_TAX is record
(
FIN_ROLE_ID number(8),
CALC_FOR_ROLE_CODE number(4));
NEED TO CONVERT TH
create or replace package CUM_A_TYPES
as
type LT_PAYMENT is record
(BASICnumber,
DPnumber,
GRADE_PAYnumber
);
TYPE TYPE_CALC_TAX is record
(
FIN_ROLE_ID number(8),
CALC_FOR_ROLE_CODE number(4));
NEED TO CONVERT THIS TO POSTGRES , ANYBODY PLS HELP ME I M NEW TO
On 08/07/2014 10:23 PM, vpmm2007 wrote:
In reply to this post by vpmm2007
create or replace package CUM_A_TYPES
as
type LT_PAYMENT is record
(BASICnumber,
DPnumber,
GRADE_PAYnumber
);
TYPE TYPE_CALC_TAX is record
(
FIN_ROLE_ID number(8),
CALC_FOR_ROLE_C
In reply to this post by vpmm2007
create or replace package CUM_A_TYPES
as
type LT_PAYMENT is record
(BASICnumber,
DPnumber,
GRADE_PAYnumber
);
TYPE TYPE_CALC_TAX is record
(
FIN_ROLE_ID number(8),
CALC_FOR_ROLE_CODE number(4));
NEED TO CONVERT THIS TO POSTGRE
vpmm2007 wrote
> type function is record (f1 NUMERIC,f2 NUMERIC..); this is in oracle
>
> kindly tell me what is the substitute to use "is record " in postgres.
>
> its urgent .
>
> thanks and rgds
> vpmm
No idea on exactly what Oracle is creating here (a type or a set returning
function)