Home » SQL & PL/SQL » SQL & PL/SQL » Recreating the sequence in the trigger Oracle 10g (Oracle 10g)
Recreating the sequence in the trigger Oracle 10g [message #411347] Fri, 03 July 2009 03:01 Go to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
How to recreate a sequence XXX inside the trigger ,can anyone help on this

Thanks in advance
Re: Recreating the sequence in the trigger Oracle 10g [message #411348 is a reply to message #411347] Fri, 03 July 2009 03:03 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Dynamic SQL (if you really want to do that).
Re: Recreating the sequence in the trigger Oracle 10g [message #411356 is a reply to message #411347] Fri, 03 July 2009 03:54 Go to previous message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why doing such a silly thing?

Regards
Michel
Previous Topic: how to create partition index on non-partitiion table
Next Topic: if condition
Goto Forum:
  


Current Time: Tue Dec 06 06:29:30 CST 2016

Total time taken to generate the page: 0.14395 seconds