DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: PL/sql trigger code !!

  1. 05-03-2006, 02:02 PM #1
    cruser3
    cruser3 is offline Senior Member
    Join Date
    Jul 2003
    Posts
    323

    PL/sql trigger code !!

    We have some vendor based code in PL/SQL where instead of ld and :new the qualifications of columns is done using numbers i.e
    :1.Datekey , :2.Acctkey and so on .

    Is this an accepted way of referencing columns in trigger code ?

    Oracle ver. 9.2.0.6


    Rgds.,

    Reply With Quote Reply With Quote
  2. 05-03-2006, 04:35 PM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    most people use old and new, but if you use numbers so be it, you can use whatever you like
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width