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: 189
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: 9167
Registered: June 2005
Location: Croatia, Europe
Senior Member
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: 28991
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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: Sun Nov 8 15:12:52 CST 2009

Total time taken to generate the page: 0.02733 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.