Declare variable

• gedeon

  SSC Veteran

  Points: 262

  More actions

  January 10, 2003 at 6:59 am

  #158535

  Hi,

  is it possible like in oracle that a local variable "inherite" the data type of a table field ?

  example in oracle:

  -- variable declaration

  v_tariff_id Tbltariff.tariff_id%TYPE;

  Best Regards,

  Michael.

  
  Best regards,
  
  Michael.

• Andy Jones, DBA

  Hall of Fame

  Points: 3641

  More actions

  January 10, 2003 at 7:07 am

  #446043

  No, but you can use user-defined datatypes.

  Regards,

  Andy Jones

  .