Go to the FreeLists Home Page Home Signup Help Login
 



[oracle-l] || [Date Prev] [04-2006 Date Index] [Date Next] || [Thread Prev] [04-2006 Thread Index] [Thread Next]

Re: pragma TIMESTAMP('2000-06-22:11:21:00')

  • From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
  • To: Krishan.Gupta@xxxxxxxx
  • Date: Mon, 03 Apr 2006 18:18:07 +0200
Krishan,

I suspect that it is a trick used by Oracle utilities (such as exp/imp) to preserve the creation or last modification date and avoid intempestive invalidation and recompiling.

HTH

Stéphane Faroult

Krishan Gupta wrote:

Hello List,



This may be a silly question, but I would like to know about what does *pragma TIMESTAMP* in pl/sql procedure or packge controls. I googled it but no luck. I would appreciate any info (your comments, links) regardiong this.



TIA

Krishan





--
http://www.freelists.org/webpage/oracle-l






[ Home | Signup | Help | Login | Archives | Lists ]

All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
Everything else ©2007 Avenir Technologies, LLC.